Click here to Skip to main content
15,741,818 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hello Friends,

It should be a simple process but unable to find solution and need your help.

The report is executing faster when I run the report locally (SSDT - VS2012) but when I deploy the report to report server, it is taking a lot of time to display the report.

I checked the stored procedure (SQL Server 2008R2) and it is running fast without any issues.

Please help. Thanks in advance :)
Shweta N Mishra 10-Nov-14 14:01pm    
it may be your report server, did you try running a static page with no database connectivity?
Joy1979 11-Nov-14 8:55am    
Hi, thanks for your reply. Report server seems to be ok as it contains many reports and if this is the case then it would slow down other reports as well.
Shweta N Mishra 11-Nov-14 10:05am    
Then that confirms that there is no issue on reportserver. Do you have any code or function on RDL which connect to DB.

Then it may happen that for each page you are connecting to DB and which slows down the report load.
Joy1979 11-Nov-14 10:53am    
Phew...As it should be a simple process, I found a solution and adding it as my answer. Thanks for your time and efforts!!

1 solution

I noticed that the issue is with one of the table in Stored Procedure. The retrieval of records from that table is taking a lot of time. If the data retrieval from the view itself is slow then I believe we can add Indexes there. It will definitely help.

In addition while testing the report, I found that after the first execution, the stored procedure was returning records faster. However, I removed the background image for slide 3 and the third slide is loading faster (1-2 sec Max) than before in test when compared to Production (10-11 sec).

Thanks all off you for your time and efforts :)
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900