Paging in SSRS 2008 shows 1 of 2?
-
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?
-
This does seem weird. Try deleting the field and re-adding it to the report.
-
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 ? 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.
"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
-
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.
-
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
"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 (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.;-)
-
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.
-
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
-
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.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply