lankapala
asked on
SSRS report output issue
Hi , When i'm downloading the excel file,i'm getting following attached error.How avoid this error
XML file output
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error042240_0 1.xml</log FileName>
<summary>Errors were detected in file 'C:\Users\abc.com\AppData\ Local\Micr osoft\Wind ows\Tempor ary Internet Files\Content.IE5\PGARRIST \Report_Is ys.xlsx'</ summary>
-<additionalInfo>
<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>
</additionalInfo>
-<removedParts summary="Following is a list of removed parts:">
<removedPart>Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml character. Line 1, column 267478.</removedPart>
</removedParts>
</recoveryLog>
1.png
XML file output
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error042240_0
<summary>Errors were detected in file 'C:\Users\abc.com\AppData\
-<additionalInfo>
<info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>
</additionalInfo>
-<removedParts summary="Following is a list of removed parts:">
<removedPart>Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal xml character. Line 1, column 267478.</removedPart>
</removedParts>
</recoveryLog>
1.png
does your report have decimals upto 18 decimal places? If yes, One option is to change data type in the table to support lower precision. Other solution is to convert the numbers in the stored procedure that populates the report.
ASKER
No 18 decimal places and I'm using stored procedure
i meant.., are there any numbers with decimal places? coz this error occurs when excel cannot read the data / too many different formats
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.