FIX: Toggle item, font color, and background color expressions do not work correctly together in SSRS

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


When a table uses a toggle item, such as the Expand/Collapse feature, the font color expression and the background color expression for the cell that contains the toggle item is not evaluated correctly.

For example, the font color of a cell that contains the toggle item is set by using expression ="Red" and background color ="Silver". In this example, the cell should be expandable by using red text and a silver background.

However, based on the value of the CanGrow property, the actual cell results may be different. This is described in the following table.

CanGrow property

Results

True

Font color expression is not evaluated.

Background color expression is evaluated.

False (toggle cell)

Cell has value and toggle. Background color expression is evaluated AND Font color expression is evaluated correctly.

False (all cells)

Cell has value and toggle. Background color expression is evaluated AND Font color expression is evaluated correctly.
 

Resolution


This problem is fixed in Cumulative Update 2 for SQL Server 2016 Service Pack 2.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.