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.
About SQL Server 2016 builds
Each new build for SQL Server 2016 contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for SQL Server 2016.
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.