Chapter 3
Formatting a Tabular Report
Section 4
Adding Calculated Fields and Using Expressions
Within the report, fields can be calculated using the data returned from the query, using SSRS built-in fields, using Expressions or a combination of all three. Expressions will allow for greater flexibility in the display of data and formatting. - Display the Report Data window, expand the Datasets folder, choose the DataSet, and right-click on Add Calculated Field - Add the Field Name and click on the formula button to define the calculated field value. - Add the new calculated field to the Report