Share via

SSRS Report runs slower in Preview Mode/Report Viewer

Vinayak Naik 6 Reputation points
2020-09-10T02:31:42.663+00:00

I am using Visual Studio 2019 and using Microsoft Reporting Services Projects Extension v2.6.7. The problem i am facing is i have a report that process about 60k records, the report is complex and has Groups, repeat headers, dataset filters and also VB Code.

The stored procedure used for this report runs in less than 10 seconds and when the report is deployed to Report Server the report completes rendering in less than 2 Mins. But when I run the same report using Visual Studio in preview or Run Mode (Report Viewer) the report runs for a whooping 17-20 mins. I have used SQL Profiler and see the Stored procedure execution time is almost same as the report execution time. The stored procedure is designed to handle parameter sniffing issue and I dont see any issue with the procedure.

I also tried to add WorkingSetMaximum to increase memory but still no luck. The client i am working with requires to have the RDLC File integrated in their app and will not want to deploy on Report Server for their own reason.

How can i make my report run faster in Visual Studio Preview Mode/Report Viewer (Run Mode) so that I can match the performance of the report with the performance i Get in Report Server.

Also if anyone could tell if there is a difference in how the report rendering works on Report Server vs Preview Mode.

Note - Report Server and the database is configured in my laptop and it is not having any different configuration.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,996 Reputation points
    2020-09-10T06:19:47.213+00:00

    Hi @Vinayak Naik

    When previewing a report, Report Designer need connect to the report data sources, run dataset queries, cache the data on the local computer, process the report to combine data and layout, and render the report. The report processor also runs all the queries for datasets in the report using the current parameter defaults, and saves the results as a local data cache (.rdl.data) file.

    You can try to improve preview performance through the link below:

    http://technet.microsoft.com/en-us/library/ee240846.aspx

    Here is an article about how to Preview Reports in SQL Server Reporting Services (SSRS).

    https://learn.microsoft.com/en-us/sql/reporting-services/reports/previewing-reports?view=sql-server-ver15

    As you mentioned, you have 60k records, if you are loading all the records in 1 page, it will take very long time to show.

    You may set the keeptogether property as false in the report or use the page break feature.

    Regards,

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.