June 25, 2015 at 2:45 am
Hi All
I have a report that is not loading in IE and sometimes taking more than 10mins to display.
The report query completes in 3 seconds and returns around 90 000 rows.
I've investigated the ExecutionLog2 table in ReportServer db and can see the data size is around 117MB (I get this from the bytecount field).
I've created another report to display 90 000 rows and that works fine. The size is 0.016MB.
I'm thinking that the size of the report is the issue...but not able to fine any definite information on this.
Thanks for any and all Reponses.
Denesh
June 25, 2015 at 2:52 pm
What is the report doing? A lot of graphs? Any images on the report? How long does the report take to run in Visual Studio/Report Builder?
Joie Andrew
"Since 1982"
June 25, 2015 at 9:49 pm
Hi
No graphs or images just tabular data.
I've not tested it in report builder...
Was told to test latest sp...getting that installed
July 9, 2015 at 7:22 am
hi
Is your table inside a rectangle ?
Did you set the property KeepTogether to True ?
If so then try to put it False on all data region
This will permit the pagination of the report
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
July 9, 2015 at 9:54 am
Did that help.
If multiple tablix try checking the datasource option : SUse Single transaction when processing the queries.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply