Calculations Tab of the Report Definition Property Editor

Users can include calculations on Numeric, Binary/Trinary, and Date/Time fields in their report results. The available calculations are addition, subtraction, multiplication, and division.

To add a calculation to a report:

  1. Select the Add column check box.
  2. In the Display box, type the name that will be displayed as the Custom Header in the report.
  3. In the Formula drop-down list, do one of the following:
    • Click the Fields tab and select a field that will serve as the first operator.
    • Click the Special Date tab and select a value such as Start of Next Week or End of This Month.
  4. Select an operand from the next drop-down list.
  5. In the second calculation drop-down list, select a field that will serve as the second operator.
The result type is displayed in the Result Type column. For example, if you specified Description = Last Modified Date - Submit Date, the Result Type is Elapsed Time.
Note: Each selected calculated column is added to the field palette. To appear in the report, they must be added to the Columns or Sort Order block.

Related Topics

Report Definition Editor

General Tab of the Report Definition Property Editor

Options Tab of the Report Definition Property Editor