July 29, 2013 at 12:18 pm
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!!
July 29, 2013 at 1:44 pm
Anything peculiar that you export?
What is the format of the excel file? .xls or .xlsx?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 1, 2013 at 9:14 pm
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.
August 28, 2013 at 8:28 am
Still have not resolved this issue...
It is XLS File type
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply