My users need to view active report saved on a network through ipad. For now, I'm testing it right from desktop(not ipad). The report is a simple list report with no graphs, data decks or images. The report is drillable but the problem is that the file size for the highest granular level of data is 75MB and Internet Explorer takes limitless time to render it.
The size of active report is a topic of subjective test but any suggestions for the file size from experienced folks would be highly appreciated.
My experience is that <10mb gives a snappy report.
>10mb and <20mb gives a runable report, but it takes some time to load.
> 20mb makes it very slow to load...
So I can understand that a ~75mb report takes looong time
I wouldn't have a report bigger than 20 mb.
Have you tried to run it in Firefox? It often runs better in FF. You'll need an addon called unMHT to be able to run it.
Yes I've tried that in mozilla as well. No response. Please note that I'm running this on desktop and not on ipad and thus I was expecting it to get rendered.
An interesting thing I found was that, the size of text file exported from a query tool is just around 5MB. Is it the xml tags that caused the mht file to explode that big? I guess I've not done any horrible things while developing the report, I simply dragged my dimension and metrics in a list.