Conditional Formatting For SSRS Report

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.