Wednesday, March 21, 2012

Reports using a lot of data errors exporting

We have a customer that has a large report that they want to export to Excel. If I try to export the entire report, it just hangs. If I run the report in 2 batches, it exports fine.

Can you tell me if there is a patch for SSRS that is going to address this or if there is a work around that I can put in my report to handle it?

The customer is quite upset at the work around so I'd love to find a solution soon.

Thanks in advance for any help!

Sherry

How much data are you talking about?

There are memory limitations in RS 2005.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2025466&SiteID=1

|||

The report seems to return only 6,393 rows of data. Of course, we could display more rows on the report due to grouping.

Thanks,

Sherry

sql

No comments:

Post a Comment