Report execution taking more time in SSRS

Question

Hi Everybody,

    I have created a Matrix report in SSRS,While executing report it is taking more time for execution. Stored procedure is a datasource for Report. Stored procedure is executing in 18 secs for 2 days data but Report is taking 1 min similarly stored procedure is taking 53 secs for 15 days data but report is taking 4mins for execution.

How can i fix this ?

Is there any way to fix this?

Thanks in advance,

Visu

Answer 1

http://www.keepitsimpleandfast.com/2011/07/more-tips-to-improve-performance-of.html

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx

http://msdn.microsoft.com/en-us/library/bb522806(v=sql.105).aspx

Checkout the performance improvement techniques

Regards,Eshwar.

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.