Problem exporting to Excel using Reporting Services
I'm having a problem exporting some reports to Excel using Reporting Services. I've created the reports in Visual Studio 2008 and the report server is using SQL Server Standard 2008. When I export the reports in Visual Studio to Excel everything is fine. When I try to do the same using Reporting Services the export fails with Excel found unreadable content in . Do you want to recover the contents of this workbook...........blah......blah. Upon answering Yes the workbook opens with lots of data missing. I've added the log below.
-
error038960_01.xml
Errors were detected in file 'C:\Users\username\Desktop\filename.xls'
-
Excel recovered your formulas and cell values, but some data may have been lost.
I've been trying to fix this for a few weeks now but I feel I'm just banging my head on the desk! It was working a few months back but suddenly we started getting these niggling issues. All the latest service packs are already installed.
Any help would be greatly appreciated.
Kind Regards
Paul