ReportBuilder3.0 Out of Memory Exception RRS feed

  • Question

  • I am using ReportBuilder3.0 against 2008R2 database. The data set i am pulling is very huge over 2 million records. The query in SSMS takes about 2 minutes to execute. The SQL is not complex. It's just selecting fields from one table.

    When i try to create a report using report builder and click run - it fails throwing an out of memory exception. I understand it's a large dataset but other than this is there any thing to fix this. When i execute the query fom the query designer (inside report builder), it runs and returns the data... but it's the preview which is failing.

    Any help is appreciated.

    Monday, February 28, 2011 7:44 PM