IE failed to generate reports

Question

One of our client is trying to generate reports with lots of sub reports, its a single page report. If they generate it for 2-3 years it works for all browsers, but when they generate it for 5 years. Report works fine in chrome and firefox but IE will not be able to load reports and show IE window "Internet explorer cannot load page".

There is no errors in eventlog or in IE console. Even Fiddler does not give any information why IE could not able to load reports. It says response 200.

Reports are generated successfully, as I can see that in log.

I am not sure why this is happening with IE(8,9,10). Please check images below Thanks

Answer 1

This could be due to the memory management problem in Internet Explorer, as you are fetching the 5 year data. There is a work around for the memory problem.

->Go IIS
->Open your reporting Website
->Check which application pool its using
->Right click on that and recycle it.
->Then try generating the report.

Not sure if it resolves your problem.

Answer 2

I've seen a very similar issue recently - it started a few months ago, across multiple unchanged reports, and seemed to be triggered by hard or soft Page Breaks (I found that out from a lengthy process of elimination).

That scenario was SQL Server Reporting Services 2012 SP1, via the Native/Report Manager portal.

Does your report render with page breaks?

My solution was to set the Report / InteractiveSize / Height to 1000cm. Then for each hard page break, I disabled it for browser rendering by setting the Page Break / Disable property using this expression:

=Globals!RenderFormat.IsInteractive

The result is a little untidy in the browser, but renders with page breaks in other formats (PDF, Word, Excel). Importantly it stopped the browser freezing in IE.