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.