SSRS report is running slow in report browser

Question

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 :)

Posted 10-Nov-14 6:28am

Joy1979

Add a Solution

Comments

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Joy1979 · Accepted Answer · 2014-11-11T04:54:00

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 :)