Solved

Reporting Services issue when exporting to Excel

Posted on 2015-01-22
1
442 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
Viewers will learn how to find and create templates in Excel 2013.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now