Insert Calculated Field

Calculated fields display statistics gathered while a report runs. For example, if you group your records by state, you could use a calculated field to print the total number of customers in each state.

Note:

You can only insert a calculated field into the Group Header, Group Summary, or Query Summary section of the Layout window. (See Inserting Objects into the Layout)

PropertyDescription

Name

Name for the calculated result. Spaces are not allowed. Assign a name to help you identify the calculated field. For example, numsales for Number of Sales or avgsale for Average Sale.

Round data entries to

If you select summation or average as the function used in the calculated field, SQR Production Reporting Studio can round each column value to a specific number of digits before adding all the values. To enable this option, select Round to and enter the number of digits to the right of the decimal point to use in the rounding calculation. To ensure that a manual calculation of report values matches the calculated total, enter the same number of digits as the width specified in the column's object properties.

Rounding only applies to decimal variables. SQR Production Reporting Studio disables the option for integers, since integers have no digits after the decimal point.

Fields/Expressions

Select a column or expression from your query.

Functions

Function to perform on the specified column or expression. Available functions are Summation, Average, Count, Minimum, Maximum, Variance, and Standard Deviation. For character and date columns (or expressions that contain character or date columns), use the Count function. Numeric columns can use any function.