SSRS 2012 background color format by expression issue when exporting to Excel
sqlserver SSRS 2012 background color format by expression issue when exporting to Excel
We are using SSRS 2012. We have a report that conditionally formats a background color for some cells. The report renders properly in a browser and in Excel 2003 format. In Excel format all cells after the first one that meets the condition are highlighted, even if only one cell should.
The sample expression that triggers this condition looks like this:
=IIF(Fields!VIOL_NOTE.Value="Internal","Green","No Color")
All cells after the first one that meets the condition Fields!VIOL_NOTE.Value="Internal" have a green background.
I got the following response from Microsoft:
I did further research on the issue we were working on and this seems to be an anomaly in the product which seems to be fixed in SQL server 2012 Service Pack1 CU3.
Following is the link to download the service pack and cumulative update:-
(Service Pack 1) (SQLServer2012SP1-KB2674319-x64-ENU.exe or SQLServer2012SP1-KB2674319-x86-ENU.exe based on the SSRS bitness level)