SSRS Report Page Number
Hi,
I have a report where there is a requirment to show the Page numbers in a table.since the Built in function for Page Number can be used only in a header or a footer , I need a help where i need to show the page number in a table.
Please let me know if there is a way to represent page number in a table.
Thanks,
Santhosh
July 13th, 2012 8:07am
Hi Santhosh,
I am afraid there is no inbuilt concrete way of achieving this..
What you can do best is to have a look at workaround given by Raymond-Lee in below thread, see if this helpful to you or not..
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ab9c18bc-ee37-45a2-a52d-628c12d08b33- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2012 8:45am
Hey Chintak,
Thank you for considering the request. I just followed the steps as mentioned in the thread provided by you, but as per that the code or the logic works only in header Or footer But it is not working for Report Body. I just wanted a way where i can display
the Page Number on report .Please help me out on this regard.
Thanks,
SanthoshPlease have look on the comment
July 16th, 2012 8:30am
Hi SanthoshH,
Just as you said, the Built in field for Page Number can be used only in page header or page footer. And you want to display them in the table of the report body. So its not supported in Reporting Services currently.
Personally, I recommend you that submit this suggestion at
https://connect.microsoft.com/SQLServer/ . If the suggestion mentioned by customers for many times, the product team may consider to improve it in the next SQL Server version. Your feedback is valuable
for us to improve our products and increase the level of service provided.
We appreciate your comprehension.
Regards,
Charlie Liao
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2012 4:40am
Thanks charlie,
I have posted a suggestion on the site as mentioned in your thread.
Thanks,
anthosh
Please have look on the comment
July 17th, 2012 4:57am
Hi Charlie,
Here is one solution which may serve the purpose and of course it has served mine. Sine Page numbers cannot be used in report body, the same can be fulfilled by the solution as shown below.
If you know that your report display say around "N" rows per page, Then u can add a column and Use this expression "= Int((RowNumber("dsQuoteDetails"))/N +1)" where N being the number of rows per page.
For more discussion on this you can follow below mentioned thread.
http://ask.sqlservercentral.com/questions/91629/ssrs-page-numbers.html#answer-91709
Thanks,
SanthoshPlease have look on the comment
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 8:09am
Hi SanthoshH,
Thank you for sharing.
Regards,
Charlie Liao
July 18th, 2012 9:15pm