Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Excel found unreadable content - SSRS 2008 Export Issue


Excel found unreadable content - SSRS 2008 Export Issue

Author
Message
mahender.s1234
mahender.s1234
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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!!
Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16511 Visits: 13208
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
donne.medley
donne.medley
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 121
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.
mahender.s1234
mahender.s1234
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 29
Still have not resolved this issue...

It is XLS File type
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search