December 29, 2016 at 3:29 pm
Can you tell me how I can find out what is wrong with an export to excel file from an ssrs 2008 r2 report?
In a new existing ssrs 2008 r2 report, I am exporting the file to excel and I am getting the following errort message when I try to open the excel spreadsheet, "We found a problem with some content in 'reprt.xls'. Do you want to try to recover as much as we can? If you trust the source of this workbook, click Yes'.
When I click the 'yes' button much of the data is gone. The excel spreadsheet is in a protected mode.
December 29, 2016 at 4:28 pm
Sounds like the xml for the document is poorly formed. This could be for a number of reasons.
For example it could be that you have a name of a sheet with an illegal character. It could be that you have formatting that is not compliant (more likely if you are using expressions to create dynamic looks). It could be poorly placed objects as well. Excel can get ery "confused" with overlapping objects as they don't conform well to cells.
What sort of data is being lost; is it a whole table, specific parts?. I would suggest looking at what is missing and a bit of trial and error. Removes those parts and see if the error persists. if not, add one part at a time and see where it goes wrong. When it does, look into that object and see if anything in it coukd be malformed, etc.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 3, 2017 at 8:11 am
I will try the options you suggested to see what could be wrong with the spreadsheet.
January 3, 2017 at 8:14 am
In ssrs reports I have never ," encapsulate your code in IFCode Markup. For example .
Would you give me an example of what you are referring to in an iif statement?
January 3, 2017 at 8:37 am
wendy elizabeth (1/3/2017)
In ssrs reports I have never ," encapsulate your code in IFCode Markup. For example.Would you give me an example of what you are referring to in an iif statement?
Not sure what you mean here? I haven't made any references to iif statements in my above post.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply