You can use computed fields in any band of the report. Typical uses with examples include:
Calculations based on column data that change for each retrieved row
If you retrieve yearly salary, you can define a computed field
in the detail band that displays monthly salary: Salary / 12
.
Summary statistics of the data
In a grouped report, you can use a computed field to calculate
the totals of a column, such as salary, for
each group: sum (salary for group 1)
.
Concatenated fields
If you retrieve first name and last name, you can define a
computed field that concatenates the values so they appear with
only one space between them: Fname + "
" + Lname
.
System information
You can place the current date and time in a report’s
header using the built-in functions Today()
and Now()
in
computed fields.