Hi, I created a report that runs in less than 2 seconds in MSVS. I deployed the report in our report server and it takes about 15 seconds for it to complete. The report is only returning about 700 rows. It uses 2 parameters that have default values when you open the report. The stored procedure that is used for the dataset contains 2 parameters: reporttype and office locaton. it also has if statements within the stored proc. I already declared local parameters in the report for parameter sniffing. pls help
Had to say where the problem can be without further details, but you can start by analyzing below views in the report server database: [dbo].[ExecutionLog] [dbo].[ExecutionLog2] [dbo].[ExecutionLog3]. Especially you can focus on below fields to identify where the issue can resist: **[TimeDataRetrieval]** - Time it took to retrieve the data from database **[TimeProcessing]** - Time it took to process the report (eg. grouping, filtering on report side etc) **[TimeRendering]** - Time it took to finally render the report. Additional infor also available on MDSN: [Report Server Execution Log and the ExecutionLog3 View] :
So I found the culprit. It was loading a while because is set the interactivesize height to 0. i did this to display the whole report on one page. When I set it back to 11in it loaded fast enough. Is there a way to display the whole report without using the interactivesize height property???