SSRS-Data Loading Error
I have created a tabular report. It's pulling data from (DataSet Script). If the run the script on SQL Query Analyzer - It's giving 1 lakhs data within 40 seconds. But, if i run the same script via SSRS - Preview --> It's giving "System.OutofmemoryException" error. While debugging, Gradually i have reduced the #of records of a table. At the maximum, the report can able to pull 10000 records (Till 10000 report is working fine). If exceeds, it's throwing "Sys.OutofmemoryException" error. Is there any settings to increase the data size of the report? Can anyone help me on this?
October 28th, 2010 10:22am
It is unlikely you will see this once deployed to Report Manager. simply add a TOP X to your query for debugging in the design environment, then remove it before deploying to Report Manager.my blog http://karlberan.wordpress.com/
October 28th, 2010 10:40am