Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Paging in SSRS 2008 shows 1 of 2?


Paging in SSRS 2008 shows 1 of 2?

Author
Message
Chris Gierlack
Chris Gierlack
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 217
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?
sam-770000
sam-770000
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 385
This does seem weird. Try deleting the field and re-adding it to the report.
Chris Gierlack
Chris Gierlack
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 217
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.
Attachments
navbar.png (87 views, 5.00 KB)
Siva Gurusamy
Siva Gurusamy
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 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
Chris Gierlack
Chris Gierlack
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 217
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.
Siva Gurusamy
Siva Gurusamy
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 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
sam-770000
sam-770000
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 Visits: 385
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.;-)
bhushan panchabhai
bhushan panchabhai
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
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.
cimscims
cimscims
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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
jalan143
jalan143
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 19
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search