1. Home
  2. Docs
  3. Designing and Running Reports
  4. Creating and Using Custom Fields

Creating and Using Custom Fields

dotnet Report Builder allows users to create Custom Fields for basic calculations. This allows users to easily add a calculation instead of a developer creating a stored procedure.

To add a Custom Field to a Report, click on the “Customize” button when choosing Data Fields in the Report Designer:

custom1

This initiates the process of creating a Custom Field. As the user selects fields, it is added to the calculation. The user can choose basic arithmetic operations to apply to the field calculation. You can only use data fields within the same table to create a custom field. You cannot combine data fields from different tables.

custom2

The user also has the option to add parenthesis to the formula by clicking the “Add ( )” button. An example of this is shown below

custom3

Another option available is to add a constant value to the equation by clicking the “Add Value” button. An example of using a constant value in the calculated field can be the following to concatenate Last and First name:

custom4

Once the field design is done, enter a name for the custom field, and click on the “Save” button on the top right corner.

custom5

Once you “Save”, the custom field will be added to the list of selected fields as shown below:

custom6

The custom field is now displayed on the report as shown below:

custom7

Was this article helpful to you? Yes No

How can we help?