Solved

Reporting Services issue when exporting to Excel

Posted on 2015-01-22
1
411 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
Comment Utility
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 to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Viewers will learn how to apply various conditional formatting in Excel 2013.
Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.

762 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

12 Experts available now in Live!

Get 1:1 Help Now