Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Creating Summary Reports : Task B: Add Functions

Task B: Add Functions
In this task you specify on which fields you want to perform numerical functions.
Print Functions Screen

 
Report: MAN_DEP_SAL REPORT GENERATOR
FUNCT - Print Functions
+----------------------------------------------------------------------------+
| SUMMARY PRINT: |
| --- ---------------- --- ---------------- --- ---------------- |
| CNT EMPNO MIN SALARY MAX SALARY |
| AVG SALARY |
| |
| FINAL BREAK: |
| --- ---------------- --- ---------------- --- ---------------- |
| CNT EMPNO MIN SALARY MAX SALARY |
| AVG SALARY |
| |
| |
+----------------------------------------------------------------------------+
...........................................................................
Functions List of Print Fields
_ AVG (AVERAGE) _ EMPNO _ SALARY
_ CNT (COUNT)
_ MAX (MAX)
_ MIN (MIN)
_ TOT (TOTAL)

 
Valid Functions
You can apply the following functions to your print fields from within the Report Functions screen:
The TOTAL function is provided as the default for all numeric print fields. This can be modified as required. The TOTAL and AVERAGE functions can be applied to numeric print fields only, that is, these fields must be of semantic data type Q or semantic data type C.
How to Add Functions to the Report
To add functions to your summary report, complete the following tasks:
1.
This section controls which functions and field pairs to print on the print lines of your summary report.
2.
A break by section appears for each break by field that you specify in the Print/Control Fields screen (that is, Subtotals). The break by sections control each function and field pair that is printed when the control breaks occur.
3.
The final break section controls the field and function pairs that are printed at the end of your report (that is, Grand Totals).

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved