SSRS bug– Exporting to Excel creates invalid file

Another new one for me, so another one I decided to write a quick little blog about.

I created a fairly simple report the other day, which has a value column, which the report owner wanted formatting to two decimal places. However when the test user was exporting the file to excel they received the following error message:

Repaired Records: Cell information from /xl/worksheets/sheet1.xml part

Not only that, but on zero value cells in my value column, the zeros were coming through as “0.000000000000000000”

A quick Google search turned up the following link:

https://connect.microsoft.com/SQLServer/feedback/details/2524655/ssrs-export-to-excel-xlsx-creates-invalid-excel-file-when-source-data-contains-zero-with-precision-more-than-14-decimals-places

So in my case the problem occurred when a view, my source stored proc was referencing,, was handling a calculated column as decimal (38,16). The workaround for me was to simply cast the column as (35,13), as testing verified this would not affect my end results.

If you genuinely need to have more numerical columns with a precision higher than 14, then I can only recommend you upvote the bug reported in the link above.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s