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


Chapter 9 Extending Report Table Attributes : Task A: Select and Sort Data and Add Breaks

Task A: Select and Sort Data and Add Breaks
This task is used to:
Control Fields Screen
The following illustration shows the Control Fields screen defined for the sample report table MONTHLY_EXPENSE:

 
-----------------------------------------------------------------------------
Sort_by A/D Break_by New Page Sort_Across_By Summary_By
---------------- - ----------------- - ---------------- ----------------
1 MONTH_NUMBER MONTH_NUMBER Y
2 LNAME
3
Selection Criteria for Report EMP_EXPENSE
1 DEPTNO >= 10 & DEPTNO <= 80
2
-----------------------------------------------------------------------------

 
Selecting and Sorting Data
The following fields are used to select and sort data. For valid values, press PF1. You can specify a combined total of 32 break by, across by, and summary by fields.
Data is sorted based on the fields typed into this field. Sort by fields are nested in the order given. In the example, MONTH_NUMBER and LNAME are designated as sort by fields.
Data can be sorted in ascending (A) or descending (D) order. If you do not type in a value, the data is sorted in ascending order.
Data can appear across the report. The across by fields control the data columns printed on an across report.
Note  If the sort fields do not match the break fields, problems could occur when running large reports.
The report can be based on compressions or summarizations of the data read. A change in the value of a summary field or a combination of summary fields causes one occurrence to be considered for output. Up to fifty entries are allowed. You use summary fields only in summary reports and across reports.
Selection Criteria for Report
You can select which occurrences you want to use for your report. The fields you use in the selection criteria must be report fields defined to the report table. You can type in up to 240 characters of selection criteria. In the above example, the selection criteria states that only those occurrences from DEPTNO 10 to DEPTNO 80 are to be used in the report.
Adding Breaks
The following fields are used to add breaks. For valid values, press PF1.
New groupings of data can be created when there is a change in the value of a break field. If you designate more than one report field as a break field these are also nested in the order given. In the previous example ­MONTH_NUMBER is designated as a break field.
If you supply a break table, the contents of the break table are printed when there is a break in this field. If you do not supply a break table, a blank line is printed when there is a break on this field. Refer to Chapter 10, Adding Break Tables for more information on break tables.
You can skip to a new page for each change in value of a break field. To skip to a new page for a break, type Y in this field. The default value is no new page (N). In the previous example, a new page is ejected as each month begins.

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