Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can I stop SSRS from attempting to render a chart? Expand / Collapse
Author
Message
Posted Tuesday, October 01, 2013 4:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, February 09, 2014 8:54 AM
Points: 32, Visits: 77
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
Post #1500338
Posted Tuesday, October 01, 2013 8:00 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 6:12 PM
Points: 827, Visits: 342
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.
Post #1500430
Posted Tuesday, October 01, 2013 10:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, February 09, 2014 8:54 AM
Points: 32, Visits: 77
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.
Post #1500494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse