We have a custom .net Report Application that is attempting to load a slightly data intensive SSRS report. Strangely, the report runs fine and returns data, albeit a little slow, when it is ran through the Report Manager and Mozilla Firefox. The problem is when a user attempts to load it through the Report Application in IE9, when all parameters are selected to maximize the data returned (20k rows), the report gets stuck on the Loading animation. The browser ultimately freezes and needs to be force-closed. There is no time-out time specified in the dataset of the report object itself, nor are any time-out settings specified in Report Manager. The Report Server execution logs show a TimeDateRetrieval and TimeProcessing time that indicates the report is loading successfully. Our belief is that there is a setting on the Report App that needs to be tweaked.
We have already configured the httpRunTime parameter in the web.config file to:
We have also attempted configuring the ViewReport.aspx file as follows
Twenty thousand rows?!?! Is someone really going to use that report and make decisions on it?
I think you have proved yourself that the issue is the amount of data being handled and the way that FF and IE do it differently. Reducing the row count will probably find you a place where IE works to but i would be looking to split this report into a summary report and then link to a detail one so that the report user can drill in to get the detail they need. With this split I'd expect IE to handle the reports with no problem.
If the report is going to be exported straight to Excel then why not point PowerPivot at the view/procedure that is supporting your report and let them analyse it in Excel from the get-go.
answered Feb 27, 2013 at 09:05 PM
We have fixed the issue by configuring the ASyncPostBackTimeOut property in the Report Viewer module to 0. Also, the pagination of the report was causing performance problems, since 20k rows were being loaded to 1 page. Separating large reports into multiple pages would also alleviate this issue.
answered Mar 04, 2013 at 03:01 PM