Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Page Counter not woking properly Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 4:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
I have a report. My report has 898 pages.
When i first load the report the page counter states that the report is:

1 of 2 ?

Then when i click next page it states

2 of 3 ?

Then 3 of 4 ?

and so forth. Does anyone know why this happens in Report Manager.

I would imagine that when the report loads it should state: 1 of 898, then when you click next 2 of 898.



Post #1432561
Posted Tuesday, March 19, 2013 1:35 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 30, 2014 2:09 PM
Points: 29, Visits: 135
I believe this is because each page of the report is rendered as you go through them. If you hit the double arrow to take you to the last page, then SSRS "knows" you have 898 pages and will then display the number of pages properly.
Post #1432880
Posted Wednesday, March 20, 2013 6:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 17, 2014 11:31 AM
Points: 26, Visits: 180
You can always use something like =CountRows("DataSetName") to show the total number of records returned from the data set. The Report Viewer renders the information so the page count will not show the total page count. But you can add the record count using code on the report itself.

HTH.

Mike
Post #1433156
Posted Wednesday, March 27, 2013 10:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 1:07 AM
Points: 7, Visits: 64
please make at bottom expression as below

="Page " & Globals!PageNumber & " of " & Globals!TotalPages


Thanks
Raj
Post #1436014
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse