Using Conditional Formatting

In a Report, the Conditional Formatting feature changes the color of a row or column based on a specific value. This feature is similar to the Color and Icon Rules; however, it is only supported with String, Int32, Decimal, and Boolean data types.

Conditional Formatting is lightweight compared to Color/Icon Rule, as it runs on the client side, whereas Rules run on the server side, which is a heavier operation on the Report.

Additionally, if both the Conditional Formatting and a Color/Icon Rule were used simultaneously, they would behave identically if the outputs were defined the same.

Example

1. In a Designer Project, select CREATE REPORT from the Global Action Bar.
2. Select and name the default Report in the resulting window, then click CREATE to enter the Report Designer.
3. In the Report Designer, click Add under Data Source. Then, expand Common and select Account Data Source.
4. Next, add Email Address, Department, and Created on Date under Data Fields.
5. Navigate to Properties > GRID VIEW, change Grid Settings Type to Specified, and change Icon Type to Image.
6. Under Properties > GRID VIEW > Conditional Formatting, select ADD.
7. In the resulting window, under FORMATTING > Apply To, select Row or Column.
8. Next, select department from the FORMATTING > Column Name drop-down list.
9. In the Values field, add a specific value. 
10. Set Background and Foreground colors to highlight the specified accounts. The Background is the Row color, and the Foreground is the Text color.
11. Choose an Icon Image, if desired. Then, select OK.
    
12. In the Report Designer, click REFRESH PREVIEW to see the updated highlighted Row or Column. Additionally, the highlights will also appear when clicking Run Report.
    

Feature Changes