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


Chapter 5 Creating Across Reports : Task A: Defining Across By Fields

Task A: Defining Across By Fields
In this task you determine which fields are to be printed across the report and which fields are to be printed down the report, using the Print/Control Fields screen. Since an across report contains only summary information, it defaults to SUMMARY only=Y in its definition. You specify the PRINT and BREAK by fields for an across report as for a summary report.
Sample Print/Control Fields Screen

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

 
Considerations
Note the following about the above sample:
The print field is SALARY. It is used in the function and field pair TOT SALARY, which is printed in each cell.
POSITION is defined as the field that appears across the report. When a new value is encountered for POSITION, a new column is created.
How to Define Across by Fields
To define across by fields, complete the following tasks:
1.
These fields control what lines are to be printed down the report (each unique field or field combination forms one line down the report).
2.
The intersection of each unique sort by and across by field value forms an across report cell.
3.
4.
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