SSRS Performance

reporting-services ssrs-2008 ssrs-2008-r2
Sinshith picture Sinshith · Dec 4, 2008 · Viewed 16.4k times · Source

I Have created an SSRS Report for retrieving 55000 records using a Stored Procedure. When executing from the Stored Proc it is taking just 3 seconds but when executing from SSRS report it is taking more than one minute. How can I solve this problem?

Answer

Nathan Griffiths picture Nathan Griffiths · Dec 22, 2008

The additional time could be due to Reporting Services rendering the report in addition to querying the data. For example if you have 55,000 rows returned for the report and the report server then has to group, sort and/or filter those rows to render the report then that could take additional time.

I would have a look at the way the data is being grouped and filtered in the report, then review your stored procedure to see if you could offload some of that processing to the SQL code, maybe using some parameters. Try and aim to reduce the the amount of rows returned to the report to be the minimum needed to render the report and preferably try to avoid doing the grouping and filtering in the report itself.

Related questions

How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
Vertical merge in SSRS Tablix

Is there any chance to do vertical merge of fields in tablix? I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.

Read More
How to hide parameter based on another parameter value in SSRS

Hi I have 2 parameters param1 and param2. param1 has values true and false.my requirement is if i select true in param1 then param2 should be hidden and if i select false in param1 then param2 should be visible. can …

Read More