Home Forums Reporting Services Reporting Services 2008 Development Can I stop SSRS from attempting to render a chart? RE: Can I stop SSRS from attempting to render a chart?

  • October 1, 2013 at 10:40 am

    #1654978

    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.