Introduction
This article shows how to use conditional formatting for SSRS reports.
Create a Report Server project as in Figure 1.
Figure 1: Report Server Project
Add a Data Source as in Figures 2 and 3.
Figure 2: Configure DataSource
Figure 3: Choose appropriate Stored Procedure
Add a new Report item as in Figure 4.
Figure 4: Add Report
Use a table as in Figures 5 and 6.
Figure 5: Insert Table
Figure 6: Choose DataSource and create a query
Formulate an expression as in Figure 7.
Figure 7: Expression
The output of the report is as in the following:
Figure 8: Output
Summary
In this article we saw how to use conditional formatting for SSRS reports.