SSRS Report Calculated Field

Introduction

This article shows how to use a calculated field 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 Data Source

 
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 Data Source and create a query

Add a Calculated Field as in Figures 7, 8 and 9.

 
Figure 7: Add calculated field

 
Figure 8: Expression

 
Figure 9: DataSet properties

The output of the report is as in Figures 10 and 11.

 
Figure 10: Output Design View

 
Figure 11: Output Preview

Summary

In this article we saw how to use a calculated field for SSRS reports.