Hi, i have this report developed in Crystal. the plan is to migrate that report to SSRS. so i create one, the same query, the same calculated fields, and so on. but why when i run the reports, it took 15-20 minutes to present the data, while in Crystal, its less than a minute. any idea why this is happening? thanks! AddinAddinGanteng

Hi AddinGanteng, It is hard to say what is the detail root cause just with the general information. I would recommend you have a check to the values in columns TimeDataRetrieval, TimeProcessing, and TimeRendering from ExecutionLog2 table in the ReportServer database when the report is executed. In this way, we could get to know the performance of each step. use below query to help troubleshoot issues. use ReportServer Select * from ExecutionLog with (nolock) order by TimeStart DESC My data takes too long to retrieve My report takes too long to process My report takes too long to render Besides this, you could also follow these articles for more information about this issue: Reporting Services Performance Optimizations: http://sqlcat.com/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx Optimizing Reports - Show the Right Set of Data : http://blogs.msdn.com/robertbruckner/archive/2009/01/12/optimizing-reports-show-the-right-set-of-data.aspx SSRS - Improve performance by automating report caching using null delivery provider: http://wiki.softartisans.com/display/BLOGS/2009/12/22/SSRS+-+Improve+performance+by+automating+report+caching+using+null+delivery+provider If you have any question, please feel free to let me know. Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Yes, calculated fields are very slow in BIDS and Report Builder. (This is due to .NET security.) But when you publish the report to Report Server, it should run at normal speed. One way to avoid this slowness is to do calculations in SQL. For example if you need a Profit column then in SQL say SELECT SALEPRICE - COST AS PROFIT FROM MYTABLE. This is faster than adding a calculated field called PROFIT defined as SALEPRICE - COST

Hi, thanks for all the answers. i have fields that were calculated using the parameters specified from user. maybe thats the reason why my reports run so slow.AddinGanteng