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


Chapter 4 Creating Summary Reports : Task A: Summarize the Data

Task A: Summarize the Data
In this task you use the Print/Control Fields screen to identify which fields to print or to use in a function that is printed, and to determine how the report appears. The Print/Control Fields screen contains the following sections:
Print/Control Fields Screen

 
Report: MAN_DEP_SAL REPORT GENERATOR
FIELD - Print/Control Fields
+-------------------------------------------------------------------- +
| SUMMARY only: Y |
| PRINT: ---------------- ---------------- ---------------- |
| EMPNO SALARY |
| |
| |
| SORT by: ---------------- A/D ---------------- A/D --------------- |
| DEPTNO A |
| |
| BREAK by: ---------------- ---------------- --------------- |
| |
| |
| ACROSS by:---------------- ---------------- --------------- |
| |
+-------------------------------------------------------------------- +
.....................................................................
Fields of EMPLOYEE
_ EMPNO _ LNAME _ POSITION _ MGR#
2 SALARY
PFKEYS:1=HELP 3=RETURN 12=END

 
Considerations
Note these considerations about the above sample:
The print fields are EMPNO and SALARY. Both of these fields are printed within function and field pairs: EMPNO as a count of employees, SALARY as a maximum, minimum, and average salary within the summarized report.
How to Summarize the Data
To display only summary data on your report, complete the following tasks:
1.
2.
The field by which you are summarizing is printed automatically and does not have to be specified here.
3.
All sort by fields automatically become summary by fields. One report line is printed for each unique value of your sort by field or field combinations.
4.
5.
6.
Refer to , Task B: Add Functions for more information on adding functions.

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