Hi Prawin, Firstly, you need to query their TimeDataRetrieval,TimeProcessing and TimeRendering from the ExecutionLog2 view, then compare which time is taken mostly to impact their performance. See http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx on ExecutionLog2 View - Analyzing and Optimizing Reports. thanks, Jerry

Prawin Pehaps you need to optimize your T-SQL query?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi, You can try creating index on the column which is used in the where condition if that is causing your performance issue.

Hi Dimant, Thanks for your early reply.In T-SQL query I just use select statement with only one where condition. In this case how to optimize, either query or report render time? Regards, Prawin

Hi All, I have developed two same reports R1 and R2. R1 is using report builder 1.0 and R2 is using Report Server Project(using MSBI). Deployed both reports R1 and R2 in ssrs server. Reports display thousands of records thats why I applied cache for both reports R1 and R2 in order to improve performance. When I compared both reports data render time, report builder report R1`s data render time is more than report R2. But for my scenario I prefer report R1 (developed using report builder 1.0). Is there any way to improve report R1(builder report 1.0) performance greater than or equal to R2 report performance, and is possible to do data render time of R1 less than or equal to R2? Thanks & Regards, Prawin