Monday 1 December 2014

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