February 23, 2012 at 3:53 pm
Hi All,
When i run a report from visual studio it gives me the following error
"An error occurred during local report processing.
An error has occurred during report processing.
Exception of type 'System.OutOfMemoryException' was thrown"
The query behind it is very simple returning 80000 records.
the server i am running the report on is 64 bit, 14 GB Ram. 3 GH
Note: when i run the query in SSMS it take 1 sec to return results, when i run the query on "Data" tab on the report itself the query takes 1 sec to return all the results. but when i design a table in "Layout" and try to preview the report it keeps rendering for around 2 minutes and throws the error.
Any Help is appreciated. Thanks in advance
Danny
February 23, 2012 at 5:13 pm
Are you trying to export to excel by chance? you will get this error when you have > 64k rows. Try to export as csv.
February 24, 2012 at 11:54 am
Nop. it wont let me preview the report so i can not export it .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply