Solved

Reporting Services issue when exporting to Excel

Posted on 2015-01-22
1
505 Views
Last Modified: 2015-01-26
Background:
We recently moved from SQL 2005 to SQL 2012.  This means reporting services also as it was on the same box.  

Issue:
Some reports when you export to excel are getting a strange message when opening them.   “Excel found unreadable content in “Active Price Page.xlsx”.  Do you want to recover the contents of this workbook?  If you trust the source of this workbook, click Yes.
If you click yes it does remove some columns so the end use can no longer trust the report.  Like I said before the reports having this issue didn’t have any issues before the move to SQL 2012.  
What I’ve tried:
I thought I may need to redeploy the report after converting it to the newer version of Visual Studio but it didn’t work.
Remove any special formatting in the report but that didn’t help either.
We then exported to CVS which works but isn’t a solution we want to use permanently.
0
Comment
Question by:abarefoot
1 Comment
 
LVL 1

Accepted Solution

by:
abarefoot earned 0 total points
ID: 40571160
I solved this myself.  The issue was with the new version of Excel not playing nice with the report.  To fix this I simply gave the users an option to save the file in the older xls Excel format.  

You have to edit the reporting services config file.
C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

Then add '2003' so users can know the correct one to select and change false to true so it will show up as an option for the users.  See  below.

<Extension Name="EXCEL2003" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="true"/>
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Viewers will learn the different options available in the Backstage view in Excel 2013.
Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question