SSRS 2012 SP1 CU6 - Issue with negative zero being passed to Excel 2013

We are experiencing a problem exporting reports to Excel 2013 when the value is 0. Seems to be well documented and there are workarounds however apparently this was fixed in SQL 2012 CU2.

My problem is we are running SQL 2012 SP1 CU6 and we have the issue. I thought service packs and cumulative updates were just that - cumulative, so I'm a bit surprised to be getting the error documented in http://support.microsoft.com/kb/2554905/en-us?sd=rss

The suggested workaround works (=IIf(Sum(Fields!Amount.Value) = -0, 0, Sum(Fields!Amount.Value)) but I was wondering if anyone else on SQL 2012 SP1 is getting the problem?

I'd rather not use the workaround if a patch is available that fixes it.

Also is it possible to run a CU for a different version of SQL. As the issue is supposed to be fixed in Cumulative Update 2 for SQL Server 2012 I was wondering if I can run that update even though we are on SQL 2012 SP

October 8th, 2013 2:54pm

Hi Darren,

As the KB your post, I recommend you try to exporting reports to Excel 2010 to check if the issue is persist. Cumulative update package 6 for Microsoft SQL Server 2012 is contains hotfixes for issues that were fixed after the release of SQL Server 2012.
Reference: http://support.microsoft.com/kb/2728897

If the issue is persist, I recommend you that submit a wish to the Microsoft Connect at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

Regards,
Alisa Tang

Free Windows Admin Tool Kit Click here and download it now
October 10th, 2013 6:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics