The report has too low performance in the IE vs FireFox

[Kezya]

Hello to all

I created report with the following properties:

a) The report contains crosstab with 90 rows and about 200 columns
b) The crosstab contains drill through definition. There are abount 15 parameters will be need to transfer to detailed report
c) The crosstab contains several conditional styles with conditional formatting
d) Report size without drillthrough datas is about 15Mb, report size with drillthrough data is abount 200Mb

I have the next software environment:
IBM Cognos BI 10.2.1 FP2
MS Windows Server 2008 R2
MS Internet Explorer 11.0.9600.17239
Mozilla Firefox 24.8.0

Runtime of the report in HTML format in the IE more than 15 minutes, whereas runtime in the FireFox no more than 3-4 minutes. Unfortunately I have no ability to provide Firefox for end users and I need to find the solution for Internet Explorer. Is it possible to improve the performance the report in the IE?

Thanks a lot!

[BigChris]

I know this doesn't answer your question, but I'd be asking whether the user is really going to be looking at 18,000 bits of data.

How long does the sql query take to run on your database server?

[bdbits]

I am going to guess that your report is fairly heavily formatted. IE has a history of being rather slow about rendering certain styles, and if that is really the only variable between the FF and IE times, well it pretty much has to be IE rendering time.

You might try making your report more basic in style and see if that helps.

I am with BigChris though - 200 columns. really? Users want that? In my experience, if they do want that it is because whatever they had before produced reports like that (*cough* mainframe reports *cough*). You can usually replace this kind of thing using drill-down/through techniques, and once the users see that they will probably prefer it. Just a thought.