Numeric/Integer Item Edits Screen [ HP ALLBASE/BRW Reference Manual ] MPE/iX 5.0 Documentation
HP ALLBASE/BRW Reference Manual
Numeric/Integer Item Edits Screen
Use the Numeric Item Edits screen to specify how Numeric and Integer item
values are edited before being printed in a report. You get to this
screen from the Define Lines screen. Choose other keys until you can
choose Item Edits. At the prompt, you type the name of the item you want
to edit.
Although the same screen appears whether you edit a numeric or an integer
item, the defaults on the screen are different, as described below the
screen.
This screen shows the defaults for a numeric item, that is, 12 digits (Z)
without leading or trailing zeros plus one digit (9) with no restriction
on leading or trailing zeros; then a decimal point (period), followed by
6 digits (9) in the decimal places.
For an integer item, the default is no decimal point, 8 digits (Z) with
no leading or trailing zeros and one digit (9) with no restriction on
leading or trailing zeros.
To specify a numeric or integer item edit
1. Use the Prev/Next Item or the Select Item function key to access
the item.
2. Type the item edit definition for this item.
3. Press Enter.
Banner Line
The banner line (at the top of the screen) shows in which lineset the
current item is positioned. This example screen shows a Detail lineset.
Field Descriptions
Item
Display. The current item.
Line/position
Display. The line and print field position of the item.
Length
Display. The print field length defined for this item on the Define
Lines screen. You can optionally change the length for this item.
Scaling
Optional. The number of places the decimal point moves to the left, or
to the right if the scaling is negative.
Decimals
Optional. How many decimal places are to be appended to the scaled
number. Note: be sure to include enough 9's or Z's in the fraction part
of the edit mask for numeric items to accomodate what is entered in this
field.
Rounding
Optional. The scaling operation for this item; one of these three codes:
T Truncate
R Round
C Ceil
Below are examples of scaling the number 3426.5809.
-------------------------------------------------------------------------------------------------
| | | |
| If scaling is: | and the number | The results are: |
| | of decimals is: | |
| | | |
-------------------------------------------------------------------------------------------------
| | | |
| | | T R C |
| | | |
| 0 | 2 | 3426.58 3426.58 3426.59 |
| | | |
| 2 | 1 | 34.2 34.3 34.3 |
| | | |
| -2 | 0 | 342658 342658 342659 |
| | | |
-------------------------------------------------------------------------------------------------
Prefix/Suffix positive/negative
Optional. Type a prefix/suffix for positive and negative occurrences of
this item. For example, the prefix or suffix can be a minus sign, Cr,
Db, brackets, or so on. Use ^ for indicating trailing blanks. [REV
BEG]The prefix or suffix takes up space in the field. Be sure to allow
for this additional space. [REV END]
Adjust
Optional. To position the prefix/suffix directly next to the number,
type an X. Default is that the prefix is left-justified and the suffix is
right-justified in the print field.
Edit mask
The edit mask for this item, using these characters:
9 digits
Z digits without leading/trailing zeros
Use ^ to show trailing blanks.
The sample screen shown on the previous page illustrates the edit mask to
print numbers with thousands characters and decimal points.
For an amount such as $69, the superfluous thousands characters are
omitted.
Note that you can also use text (THOUSANDS, DOLLARS, etc.) within the
edit mask.
When zero print text
Type the text to be printed if the item value is zero. You can do this
separately for the integer part and the fraction part, for example:
-.--
Use ^ to show trailing blanks.
Justify
Type one of the following:
L left justify
C centre
R right justify
Default is to align on the decimal point.
Prefill with Character
Optional. Specify the character to be printed instead of leading blanks.
See the following examples in which an asterisk is the prefill character:
If you use an adjusted prefix, the result is:
*******-49
Without an adjusted prefix:
-*******49
"No Value" Character
Optional. The print field is filled with this character if the item has
no value.
"Error value" Character
Optional. The print field is filled with this character if an error
value occurs.
"Field overflow" Character
Optional. The print field is filled with this character if the item
value is too long for the edit mask.
Softkeys
Select Item
Prompts for the name of the item to be accessed.
Select Lineset
This choice prompts for the level and type of lineset to be accessed.
You respond with:
P (for page) plus H (page heading) or F (page footing)
R (for report) plus H (report heading) or F (report footing)
1 - 9 (break level) plus H (break heading) or F (break footing)
D (for detail line)
MPE/iX 5.0 Documentation