SSRS Report: Show number of record per page
Scenario:
I have a setup my report to show 25 records per page and now I want to display the number of the records each page to be displayed dynamically. I can set 25 in the page footer easily, as I know I have set 25 records to show for each page, but the problem is, number of record in the last page will always vary in the report.
Solution:
Use expression
=iif((Globals!PageNumber * 25)>CountRows("MainData"),CountRows("MainData") mod 25,25)
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home