sql server reporting services: Error while trying to export to Excel -- sql server reporting services

Error while trying to export to Excel

Adam
7/21/2007 3:10:01 PM

sql server reporting services: One of the RS2005 users is complaining that they are no longer able to export
data to Excel. The problem is specific to just one report. Following is the
error I am getting.

w3wp!ui!8!7/21/2007-16:51:14:: Unhandled exception: System.Exception: An
error occurred during rendering of the report. ---> System.Exception: An
error occurred during rendering of the report. ---> System.Exception: Excel
Rendering Extension : Number of columns in the Excel sheet exceeded the limit
of 256 columns.

Re: Error while trying to export to Excel

EMartinez
7/22/2007 1:18:06 AM

[quoted text, click to view]

There seems to be very little documentation on this Excel limit error.
If nothing has changed in the report itself, I would suggest re-
uploading the report to the report server. If this does not work, you
might try rebooting the server itself (of course this is a long shot).
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant