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

Paging in SSRS 2008 shows 1 of 2? Expand / Collapse
Author
Message
Posted Tuesday, April 28, 2009 1:21 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, June 3, 2013 11:57 AM
Points: 116, Visits: 216
We just upgraded from SSRS 2005 and now when a report loads, the paging adds a question mark to the end and doesn't display the total number of pages unless I click on the |> and it navigates to the last page, then it shows. Is this a setting in the report? Has anyone seen this?
Post #706210
Posted Monday, May 4, 2009 11:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:38 AM
Points: 61, Visits: 314
This does seem weird. Try deleting the field and re-adding it to the report.
Post #709527
Posted Monday, May 4, 2009 1:20 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, June 3, 2013 11:57 AM
Points: 116, Visits: 216
What do you mean delete the 'field' and re-add it to the report. This is in the main nav bar for paging through any report. It happens on new reports or converted ones....I'm attaching a screen shot of what it looks like.

  Post Attachments 
navbar.png (69 views, 5.22 KB)
Post #709654
Posted Tuesday, May 5, 2009 7:41 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
The ? is not just a ?.
In 2005, if a report had 180 pages worth of records all were rendered as a whole.

In 2008, only a page worth of data is rendered onto the client. Only when you click next, the next page worth of data is rendered.

The objective is to minimise load on the client box.






View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #710198
Posted Tuesday, May 5, 2009 8:56 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, June 3, 2013 11:57 AM
Points: 116, Visits: 216
So you're saying that one is by design? HA! That's pretty funny actually. When my customers call in asking what that is, I can now tell them that there may be 2 pages or 200 in the report, it's added fun to page through and see!!

Okay seriously, I understand the potential for massive performance increase by processing what is shown on the page versus the entire report, I just wish they could have thought of something better than a (?) to display...reminds me of bad developer humor that accidentally made its way into production.
Post #710321
Posted Tuesday, May 5, 2009 9:08 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
The buzz word is On Demand Report Processing.

http://msdn.microsoft.com/en-us/library/bb630400.aspx#OndemandProcessing

And for the pros and cons of this please see Robert Bruckner here: http://blogs.msdn.com/robertbruckner/archive/2008/08/11/on-demand-report-processing-in-rs-2008.aspx






View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #710341
Posted Tuesday, May 5, 2009 9:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:38 AM
Points: 61, Visits: 314
Chris Gierlack (5/4/2009)
What do you mean delete the 'field' and re-add it to the report. This is in the main nav bar for paging through any report. It happens on new reports or converted ones....I'm attaching a screen shot of what it looks like.


The image you uploaded helped clarify the issue. Glad Siva was able to input as well. I guess this is one of those weird querks you need to contact Microsoft about.
Post #710355
Posted Thursday, July 30, 2009 7:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 16, 2010 9:11 AM
Points: 21, Visits: 45
This is a new feature of SSRS 2008. Check out - http://msdn.microsoft.com/en-us/library/ms143200.aspx

There are two ways to get around this -
1. Ask users to Click "Last Page" button(From 'report manager'/'report viewer' top toolbar) after report is generated. After clicking this button, total number of pages will appear instead of question mark and it will always remain there if we go to any page page of that report till we close the report.
2. If we put a textbox in header or footer containing "=Globals!TotalPages" (This property is allowed only in header or footer.), the report will display the total number of pages instead of question mark when rendering first page. We can hide that textbox.

Please let me know if this works for you as well.
Post #762393
Posted Monday, December 20, 2010 2:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 2, 2012 7:54 AM
Points: 8, Visits: 24
2. If we put a textbox in header or footer containing "=Globals!TotalPages" (This property is allowed only in header or footer.), the report will display the total number of pages instead of question mark when rendering first page. We can hide that textbox.

The above solution worked. Excellent
Post #1037404
Posted Tuesday, July 22, 2014 4:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 1:23 PM
Points: 3, Visits: 5
In the page header insert a text box, set the expression to totalpages and hide it. Now you will able to see the page numbers.
Post #1595306
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse