The detail information about enable the Excel 2003 rendering extension, you can refer to the thread below: So, please export the report from report manager and check the result again. After that, the Excel 2003 rendering format will be available on report manager (notĪvailable in Report Designer). At this time, I suggest that you enable the Excel 2003 rendering extension by modifying the nfig file. By default, the previous version of the Excel rendering extension,Ĭompatible with Microsoft Excel 2003, is disabled. =IIf(Fields!id.Value=5, 'Green', 'White')Īdditionally, in SQL Server 2012 Reporting Services, the Excel rendering extension renders a report to the native format of Microsoft Excel 2007-2010, the format of which is ExcelOpenXML. In this situation, we can use the expression below to replace the above expression to solve the issue: =IIf(Fields!id.Value=5, 'Green', Nothing) As per my understanding, we may meet the issue when we use an expression that resembles the following for the Backgroundcolor properties:
