~* Data Loading in Reports *~

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.




Answer this question

~* Data Loading in Reports *~

  • Arobind

    "In future releases" means "Maybe within the next 5Years". Even a MS-Hotliner told me, that such changes would usually not make their way to a released version.
    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

    The preview doesn't follow the page-sizes! We don't use the Reports-Webapp, but a selfmade Webapp that renders the reports as PDF by default. The PDF has the same pagenumbers like the printed output and the PDF looks the same on all browsers and platforms, IE, FireFox, Mozilla..


  • 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.



  • ~* Data Loading in Reports *~