March 28, 2014 at 11:56 am
I have one ssrs report, when we run th report, its loading page opens very late, once it start showing loading page then data comes very fast. I executed the same proc which we are using in the rdl, that proc is taking very less time. After loading the page when i chnaged the parameter and give maximum input , still the output comes in seconds. I am attaching the screen shot, which shows the pre and post loading page. Pl suggest why the laoding page come very late.
Thanks
April 1, 2014 at 3:50 am
Are the parameters for the report pre-filled? If so, the queries which support those how are they performing?
May 23, 2014 at 12:08 pm
It could just be the report server that renders the report may be low on Ram or disk space, running a heavy process (maybe a anti-virus scan). Have you looked at the server and its resources? Does it load this slow on all clients?
----------------------------------------------------
May 26, 2014 at 4:17 am
need to check Report execution status in the executionlog3 table to nail it to the core.
May 27, 2014 at 9:43 am
higgim (4/1/2014)
Are the parameters for the report pre-filled? If so, the queries which support those how are they performing?
+1
It needs to generate all the data and render it for the drop downs.
If you have thousands of customers, and each on can have many projects, you need to dive a bit deeper into how these are being filled.
For example, project depends on Customer.
So that shouldn't fill until you have picked a Customer.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply