Entering Characteristic Information for a Column Block Once you have entered a column set on the
Create Report: Columns
screen, you can enter additional information for each characteristic used in the report column, such as page breaks and additional space between physical report columns.
On the
Create Report: Columns
screen, move the cursor to the column set for which you want to enter characteristic information and choose
The
Column Characteristic
dialog box appears.
Enter the following data in the
Settings for totals
group box as required:
– See the definition for the
Total level
field in
Entering Characteristic Information for a Row Block
.
– Specify whether you want the system to suppress the sum column for the characteristic (
Suppress charact.
indicator). If you set this indicator, only columns for the detailed values of the characteristic are printed. This field does not appear for the last characteristic listed of the current column set.
– See the definition for the
Int.Bus.Vol.Elim.
field in
Entering Characteristic Information for a Row Block
.
Enter the following page break information as required:
– The level you enter in the
Unconditional
field tells the Report Writer at which level to place vertical page breaks in the report. The default (blank) places page breaks at fixed intervals as defined by the
Width
field in the
Create Report: Layout: Page/Control
dialog box.
You can enter the following values:
0
Place page break at fixed intervals as defined by the
Width
field in the
Create Report: Layout: Page/Control
dialog box.
1 Place page breaks at the end of every first level of the set characteristic.
2 Place page breaks at the end of every second level of the set characteristic.
n Place page breaks at the n th level of the set characteristic.
1- Place page breaks at the lowest level of the set characteristic (all levels).
2- Place page breaks at the end of every basic set.
You can only use a value for a specific level if it is not suppressed via the
S
indicator (Suppression) within the set hierarchy.
For this field, you can only use as many numeric values as there are levels within the set hierarchy. 1- and 2- are the only negative values possible.
For example, you cannot enter 5 in this field if there are only four levels within the set hierarchy.
– The
Conditional
field implements an "intelligent" vertical page break facility. The system checks if there is enough room on a page for the next level of columns before inserting an automatic page break after a specified level. The default (blank) is no intelligent page breaks.
Values are the same as for the
Unconditional
field.
You can use the
Conditional
field:
a) If you want all of the months in a quarter to appear on one page.
b) If there is enough room on the current page for all of the months in a quarter; the months should print on the same page.
The system only starts a new page for the next group of months in a quarter if the group does not fit on the same page.
Enter data in the
Totals display
group box as required:
The
Totals display
fields allow you to enter a number range of levels and then:
- Place characters to the left and/or right of a column
- Insert additional blank columns between levels
Use the
From level
field to select a beginning level number for the
Left border
and
Right border
fields (explained later in this section). Valid values are the same as the
Unconditional
field.
Use the
To level
field to select an ending level number for the
Left border
and
Right border
fields (explained later in this section). Valid values are the same as the
Unconditional
field.
Set the
Left border
indicators depending on how you want the left border for the column characteristic totals to appear. You can define the left border so that no left border appears, a single line appears, or a user-defined character is used for the border.
Set the
Right border
indicators depending on how you want the right border for the column characteristic totals to appear. You can define the right border so that no right border appears, a single line appears, or a user-defined character is used for the border.
If you want to enter additional level information for displaying column totals, choose
Additional
.
A dialog box appears, displaying the
Totals display
fields for the additional level.
If there are additional characteristics to define for the column set, select the
Next characteristic
button.
Choose
Continue
.
You return to the
Create Report: Columns
screen.