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.