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


Chapter 5 Creating Across Reports : Task B: Add Functions

Task B: Add Functions
In this task you specify on which fields you want to perform numerical functions.
Report Functions Screen
A portion of the defined Report Functions screen for the sample across report is illustrated below:

 
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) _ 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 each numeric print field. 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
You can add functions to an across report in the same way that they are added to a summary report. Refer to How to Add Functions to the Report for information on adding functions to summary reports. If you have not yet defined break and summary fields for the report, you can add functions by completing the following tasks:
1.
Insert an S on the line command field of the function you want to perform.
2.
Insert an S on the line command field of the print field on which you want to perform the function.
3.
4.

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