Report generated by ReportViewer shows error message in Excel

Question

If I create an excel-report, excel 2010 displays the following warning message:

file error: data may be lost

Note. I have already found a solution and will publish it immediately. I am making this entry for other people with the same error.

Answer 1

It turned out that the report data source has a value of -0 (negative zero). The data type was decimal . Excel cannot handle this.
The problem seems to be the Excel formula engine, not the report renderer (however, I think MS should solve the problem with the report renderer).

http://connect.microsoft.com/SQLServer/feedback/details/680863/negative-zero-causes-file-error-data-may-have-been-lost-in-excel-2010-when-exporting-ssrs- report

Answer 2

I had a similar problem when I changed inline images to external images. In this change, some properties of the Bit Bit image are kept at 32 (click on the Property → Details tab).

I changed its bit to 24 using the imagemagick utility (http://www.imagemagick.org/ script / binary-releases.php).

I used the command "convert -depth 24 oldimage.bmp newimage.bmp" to change the bit depth property.

And that solves my problem.

I know this is not a solution to your problem. But if someone meets this post in a search that can help them.