October 1, 2013 at 4:35 am
Hi,
I have a report that errors with the message "System.OutOfMemoryException"
The report had a number of charts, but some of these have no data. They display the axis but not the bars. Is there a way to stop SSRS from processing these charts? I can hide them, not a problem but I want the report to not attempt to create it based on logic looking to see if there data for the bars is there.
Thanks
Eliza
October 1, 2013 at 8:00 am
May be number of queries in the report cause OutOfMemory exception. Tyr tuning the queries. You may handle rendering of report by checking record count, but what if the query itself is taking time to execute. If possible, use only one query to get results for all charts.
October 1, 2013 at 10:40 am
Amit Raut (10/1/2013)
May be number of queries in the report cause OutOfMemory exception. Tyr tuning the queries. You may handle rendering of report by checking record count, but what if the query itself is taking time to execute. If possible, use only one query to get results for all charts.
Hi,
Thanks for your reply.
I only have one query that takes about 8 seconds to run without any charts. In Sql management studio it's even quicker. I think the issue is I have for each "detail row" a chart, which works out at about 20,000 rows. However not each of these rows has the complete data to make the chart. The report draws the axis regardless. If I add where clauses to the query to show only were we do have complete data the report runs with no issues.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply