How to add a calculated field to a report


#1

In the report designer, select the Field List for collectionDataSource1
05Capture


#2

Right click any field in the field list and select
Add Calculated Field


#3

Right click any field in collection data source and select Edit Calculated Fields
07Capture


#4

Edit the properties for your calculated field.
Make sure to set the Data Source to be collectionDataSource1
08Capture


#5

Click Into the Expression Editor to set the expression for the calculated field09Capture


#6

Now you should be able to use your calculated field as a normal field on your report