RS2005: Export to Excel error: Destination array was not long enough. Check destIndex and length

All,

I am using Reporting Services 2005. One of my reports is getting the following error when I try to export to Excel. It will export to .CSV though.

"Destination array was not long enough. Check destIndex and length, and the array's lower bounds."

Any suggestions would be greatly appreciated. Please copy me at machelle.a.chandler@.intel.com.

Machelle

What is the length of the longest string in the cells that you are trying to export?

Here is another description of similar bug:

http://dev.devbiz.com/forums/thread/1500.aspx

Seems as though the description in their case is too long to export.

|||I have exactly the same problem you mentioned Machelle. I guess it is because there is a certain limit for the data amaount in an Excel cell. Not the Excel cell itself but the buffer related to it. Exporting occassionally works when there is no cell with large amount of data.

I could not find a solution though. Any suggestion is appreciated.

EKREM