Hi,
I have a report with atleast 1000 pages. my question is, when the user requests for the report, will all the 1000 pages load at one time or will they be loaded when user clicks the "next page" link...
are there any ways to improve the performance...
Thanks in advance ..
Cheers![]()
Chakri.

~* Data Loading in Reports *~
Arobind
To answer your question where to find important updates:
http://www.microsoft.com/sql/default.mspx
or
http://www.microsoft.com/downloads/results.aspx freetext=sql%20server%202005&productID=&DisplayLang=en
If a update is important MS will announce it (like SP1)
rlo
Hi,
Thanks Mr.BenniG.
I have one more query.
The number of pages in the report viewer and the number of pages in print preview are different. how could the prob. be resolved...
for eg.,
the report viewer has 8 pages, but when i view in print preview the total pages are 11.
if the user need first 5 pages tobe printed as per the view in report viewer, he may not get the desired records, as the records may be pushed to some other page as per the print preview.
hope i am clear..
Thanks in advance.
Cheers
Chakri.
Luis Ricardo Velho
Hi,
I also have the same problem. The number of pages that appear in Report Viewer control in my web application are different from what I get when I export or print the report. Also, I have written some code to print the report programatically, where, I first get the number of pages and then take them in a byte stream and send them to print. Now, I am getting the number of pages itself as wrong, so less pages are getting printed.
So, I have the same questions -
Is there any way to make the total pages in the report viewer as in print preview
Can the report be displayed in print preview mode in the report viewer by default
How can I get the correct number of pages
Where can I set the default setting of reports to be rendered in PDF
TIA!!!
Babroberg
Hi,
Thanks for the reply Mr.BenniG. But still, to render the report in PDF format, the client should have the Acrobat Reader installed.
is there any way to make the total pages in the report viewer as in print preview. (or) can the report be displayed in print preview mode in the report viewer by default.
Thanks.
CHolmes
erossetto
All 1000 pages will load. In future releases, we are looking at ways to improve this performance so that every page does not load as you mentioned.
I would suggest to limit the amount of data to what is really relevant. A 1000 page report is a lot of data for a person to have to read. Filtering the data to what is necessary is usually in the clients best interest.
prasad mamidi
Hi,
Thanks for ur reply Mr.Brad. But where i can find the latest updates for SQL Server Reporting Services. I mean, in case if the performance of the report is improved by making the page load one by one.
Thanking you.
Cheers
Chakri.