Export SSRS 2005 Report to Excel

Hi,

I have created a report in SQL Server 2005 Reporting Services. After I export it to Excel format, if I try to print it (Hardcopy), my Excel crashes. It shows an error and shut down. I'm using Excel 2000. It even shows me same error when I click on "Print Preview", in Excel.

Everytime I try to print the excel worksheet, a window pops up with the heading "Visual Studio Just-in-Time Debugger". The error is: "An unhandled win32 exception occurred in EXCEL.EXE [3460]".

Any help is greatly appreciated.

Perm

Hi Perm,

What happens when you save and re-open the Excel Report?

|||

Thanks for the reply.

I can save it and re-open it without any problem. Excel crashes only when I click on "Print Preview" or when I try to print a hardcopy.

|||This sounds like an Excel issue, but maybe I can help narrow down the problem. What report objects do you use in your report and how are they formatted? You can send the RDL and\or this information directly to me so I can take a look and try to see what the cause is. bradsy@.removemicrosoft.com|||Was this ever solved? I have a user who is running into the same issue and am having trouble finding a solution to this.