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_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\abc.com\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\PGARRIST\Report_Isys.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

Manju

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.

lankapala

ASKER

No 18 decimal places and I'm using stored procedure

Manju

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 TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

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.