Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel found unreadable content - SSRS 2008 Export Issue Expand / Collapse
Author
Message
Posted Monday, July 29, 2013 12:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 30, 2013 9:56 AM
Points: 2, Visits: 29
Hello - Whenever I export my report to excel and open the downloaded file, I am getting the following error - "Excel found unreadable content. Do you want to recover the contents of this workbook?". When I click Yes, it is showing completely different/irrelevant contents and format. I researched a lot about this topic on the internet and applied many of the fixes suggested but none of them seem to work which is very frustrating. Can you please suggest any fix for this error? Thanks!!
Post #1478697
Posted Monday, July 29, 2013 1:44 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
Anything peculiar that you export?
What is the format of the excel file? .xls or .xlsx?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1478732
Posted Thursday, August 1, 2013 9:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 20, 2014 3:40 PM
Points: 11, Visits: 87
Hi, I have recently had this issue in SSRS2012 when trying to export reports to Excel. I found the problem was caused by -0 values in the report. These values appeared where I was trying to calculate a percentage by dividing two field values in the expression of a cell. Changing the format of values on the report did not fix the problem. The problem was made more complex because the cell concerned was being sub-totalled and totalled.

I was able to resolve the problem by doing the following:

1. calculate the percentage values in a calculated column in the dataset
2. use this calculated value in a SWITCH statement in the expression of the cell to filter out any values that equal zero
3. do the rest of the percentage calculation in the cell expression to enable correct sub-totalling

Here is an example of my SWITCH statement:

=SWITCH(
sum(Fields!percent_change.Value)=0,0,
sum(Fields!percent_change.Value)<> 0, sum(Fields!net_donors.Value) / (sum(Fields!active_donors.Value)-sum(Fields!net_donors.Value)) * 100
)

Hope this helps.
Post #1480237
Posted Wednesday, August 28, 2013 8:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 30, 2013 9:56 AM
Points: 2, Visits: 29
Still have not resolved this issue...

It is XLS File type
Post #1489257
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse