Page numbers in Reporting Services
It wasstated inthe post belowthat page numbers can not be accessed in the body of a report. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=105823&SiteID=1 I amcreating a complex report that runs up to several thousand pages in length. Due to the length of the reportI need to duplex the report. Different parts of the report are sent to different people, so details sections need to start on odd pages. In the past, in Crystal, this was accomplished by suppressing a blank section based on page number. I have been looking at this for several weeks, and have not come up with a method of accomplishing the goals using Reporting Services. Does anyonehave any ideas as to how I should try to meet the requirements and use Reporting Services?
October 4th, 2006 9:33pm
I have also posted this same problem a while ago and nobody seems to have an answer, come on MVPs please help!!. Really need this problem to be solved. All I have managed to find out is that you cannot use the pagenumber details in the body of the report this is because the page numbering happens after the whole report is generated. You can't really use a counter on your groups as you have no way of knowing how big your group will be and this will vary between different reports or datasets. I think by using a subreport you maybe able to solve this but I can't figure it out.
November 7th, 2011 4:08am
This issue is caused by the render mode of Reporting Services. Repoting Services will render the report body firstly, then the report header/foot. After the body rendered, Reporting Services calcaulate the how much page there will be. So we cannot use pagenumber in the body. There is a way I will try is using row number. For example, you add page breaks after every twenty rows. Then you can use row number between 1-20 and admire these rows should be in Page 1. also, 21-40 will be in Page2.... Hopefully this helps.Yao Jie Tang -Microsoft Online Community
November 7th, 2011 6:05am
Using the row number will not work, yes it will add a page break however without knowing if the page is odd or even you cannot conditionally force the page break so that the new group starts on an odd page. Does anyone know if the next release of reporting services will have this feature, start new group on an odd page this would definately save a whole load of trees!!!
November 7th, 2011 9:20am
The row number I mean is not based on the report. You need the row number based on the dataset.
November 10th, 2011 2:16am