Question Locked

Problem exporting to Excel using Reporting Services

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.