Displaying the Detail FillIn

Fill-In Descriptions › Detail Definition Fillin › Displaying the Detail FillIn

Displaying the Detail FillIn

To display the report Detail fill‑in, enter the command DETAIL on the command line or press the F6 key. If you are editing an existing report definition, the EDIT command places you directly in the Detail fill‑in.

The Detail fill‑in is shown below.

=>
 ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
 IDEAL   : RPT DETAIL DEFN.      RPT CUSTRPT  (001) TEST           SYS: DOC  DISP 

         Field Name, Literal,      Sort   Break  Function Column 
         Function, or               L A   L S I  T M M A  H W    
 Command Arithmetic Expression      V /   V K N  O A I V  D ID Tab Edit Pattern 
                                    L D   L P D  T X N G  G TH   
 ‑‑‑‑‑‑  ‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑  ‑ ‑   ‑ ‑ ‑  ‑ ‑ ‑ ‑  ‑ ‑‑ ‑‑‑ ‑‑‑‑‑‑‑‑‑‑‑‑‑
 ======  =========== T O P =======  = =   = = =  = = = =  = == === =============
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ______  _________________________  _ _   _ _ _  _ _ _ _  _ __ ___ _____________
 ======  ========= B O T T O M ===  = =   = = =  = = = =  = == === =============

Command

Enter CA Ideal editing line commands here. Refer to the editing section in the Command Reference Guide for information about using editing line commands.

Field name, literal, function, or arithmetic expression

Specifies the report group name, field name, literal, function, or arithmetic expression to print on the detail line. This area must be left blank if you specify Lnn or P in the TAB column.

If a field name, function, or arithmetic expression does not fit on one line, you can continue it on a subsequent line by terminating the entry text with a semicolon immediately following the field name and continuing on the next line. Leading blanks are ignored on subsequent lines. You cannot continue a literal with a semicolon. You can specify literals on consecutive lines with a TAB specification of +0. They are concatenated in the detail. To leave a space between the two pieces of the literal, you can specify a TAB value of +1 or include the space as part of one of the pieces of the literal.

For information in the following fields of the Detail fill‑in: You can also use a semicolon here to continue the entry's edit pattern. Any other specifications for a multiple‑line entry must be indicated on the first line of the appropriate column.

To modify the specification, use the ERASE EOF key or the DELETE key to delete a field name that is no longer wanted. When you delete a field name, the corresponding options specified on that line are also deleted.

Group Name

Specifies a label for the detail group. A group name is specified in the following format:

<<label>> [GROUP]

If specified, you must enter a group name must be entered on a line by itself before the first line of the detail definition it identifies.

Field Name

Field names must be the names of fields in dataviews, panels, working data, or parameter data. For field names, the following conditions apply:

For alphanumeric and variable fields, the maximum field length is used unless a column width is specified. You can specify an edit pattern.
For numeric fields, you must specify an edit pattern.
For date fields, you can specify an edit pattern. If one is not specified, the date format is the default defined by SET COMMAND DATEFOR.
For dataview fields, the dataview name must prefix the field name.

Fields specified with null values appear as question marks padded with blanks to the total field length. If alphanumeric, the field is left justified, followed by blanks. If numeric, the field is right justified, preceded by blanks.

Function

You can specify any CA Ideal PDL function. You can also specify the report function $OCC as the field name to print the count of primary records.

Arithmetic Expression

An expression that derives a result from an arithmetic operation using field names, literals, or functions as operands. Arithmetic expressions can be named or unnamed. You can use the result of a named expression in another expression.

Sort

Specifies a sorting order for detail lines in the report different from the order in which lines of the report were produced. The sorting order is specified using two values, the sort level of the field and the direction of the sort.

For reports with no sorting specified, the order of the detail lines in the report is the order in which the lines were selected or produced. See the ORDERED BY clause on the FOR EACH statement in the Programming Reference Guide for information on how to sequence selected records. The FOR EACH statement in the application procedure selects data and usually accompanies the production of reports.

A primary‑group and secondary‑groups always appear in the order they were produced. For reports with a sorting order on a primary group, the primary group and its associated secondary groups remains together.

LVL (level) Specifies the order in which fields are sorted. If omitted, this field is not sorted.
- Specifies this field as the first or major sort field.
- 2-9 Specifies this field as a second or a minor sort field. You can indicate up to nine levels of sort fields. You can assign these numbers to fields in any order, but they must form an unbroken sequence. (For example, 1,3,2 is acceptable, but 1,3,4 is not.)

Note: Fields containing null values are sorted after any other numeric or alphanumeric values.

A/D (Ascending/ Descending)

Specifies whether the sort is in ascending or descending order.

A Sort in ascending order (default).
D Sort in descending order.
+(plus) Sort in ascending order, based on the alternate collating sequence, if one has been defined through the site's sort package.
-(minus) Sort in descending order, based on the alternate collating sequence, if one has been defined through the site's sort package.

Break

Specifies the format of a control break. Control breaks are not allowed on secondary groups.

LVL (level) Establishes control fields and their relative levels. If a value is not entered here, the field is not used as a control field.
- 1‑9 Specifies the field as a control break field. The control break level is assigned in decreasing order of importance as the number increases. For example, LVL 1 is the first or major control break field; LVL 2 is the next; and so on. You can assign control break levels to fields in any order, but they must form an unbroken sequence without duplicate numbers; for example: 1,3,2 is acceptable, but 1,3,4 or 1,2,2 is not.
SKP (skip) Indicates the spacing from the previous control footing to the current control heading when a control break occurs. If this field is left blank, the spacing is the same as the Spacing Between Lines option specified in the Parameter fill‑in.
- P Positions the report to the top of a new page.
- R Resets the page number to 1 and positions the report to the top of a new page.
- 1‑9 Specifies the number of lines to skip.

You can override this field with the TAB specification for the control break heading <<BH>> in the Heading fill‑in.

IND (indication) Specifies whether the control field value prints to indicate the beginning of a new group, for all detail lines, or not at all. If nothing is specified here, the control field prints only when the value changes.
G Control field prints in detail lines when the value changes.
R Control field always prints (repeats) in all detail lines.
N None, control field does not print in detail lines.

Function

Specifies summary operations to perform against this field. The resulting value prints in all user‑defined break level footings and in standard control breaks: standard break levels, page footings, and report footings. If the function column is left blank, the function is not performed and no value prints for that field.

For each of the following functions, you can specify A for annotated or S for summary:

A Prints an annotated value on a separate line. The annotation consists of the column heading and the field value. If the column heading normally prints on more than one line, the sections of the heading are concatenated to print on one line.
S Prints all values on a single summary line beneath the corresponding columns.
Note: When any of these functions are requested, the default width of the associated detail field is computed as the implied width of the detail field plus 4. You can override this default explicitly in the Width field.
TOT (total) Specifies whether a total is computed and printed.

A question mark in the leftmost position of a summary total indicates either that the user‑defined edit pattern is too small or, when no edit pattern is specified, that the TOTAL requires more than four extra positions.

MAX (maximum) Specifies whether the maximum value that occurs for the field in the control break group is computed and printed.
MIN (minimum) Specifies whether the minimum value that occurs for the field in the control break group is computed and printed.
AVG (average) Specifies whether the average of all values of a field in the control break group are computed and printed. Nullable fields cannot specify the AVG option.

Column

The options under this heading specify whether column headings are printed, define the width of the report column, and specify the placement of the column on the detail line.

HDG (heading) Specifies what is used as the column heading for fields in the primary group.
- N No heading is printed.
- U The user‑defined heading specified on the Column Heading fill‑in is used. The U appears automatically when a heading is defined on the Column Headings fill‑in.

If you leave this field blank, the column heading specified in the dictionary facility is used if available. If no column heading is specified in the dictionary, the field name is used. When a literal value is defined on a detail line, the column heading for the literal value must be user‑defined. In this case, you cannot leave the HDG option blank.

Note: The column heading derived from the cataloged dataview contains a maximum of 20 characters, even though the cataloged dataview heading fields can have up to 36 characters and the field names can be up to 32 characters. You can define longer headings on the Column Heading fill‑in.

WIDTH A value of 0 to 99 that specifies the width of the column. A width of zero suppresses printing of the field on the detail line but allows MIN, MAX, AVG, and TOT to print as annotations only. An entry here overrides the default column width. If the field value is larger than the space allotted, it is truncated. Truncation of alphanumeric fields is on the right. Truncation of numeric fields is on the left.

If this field is alphanumeric and blank, the width is equal to the largest of the following:

The width of the source field.
The width of the column heading.

If this field is numeric and blank, the width is equal to the largest of the following:

The width of the column heading.
The width that results from the edit pattern.
A width of four characters larger than the edit pattern width if a summary total is specified.

If an alphanumeric function such as $SUBSTR is specified, a WIDTH specification is required. When using an alphanumeric function, the width must be a positive number greater than zero. The column width is required to define the length for a function's result, otherwise a compile error occurs.

TAB

Specifies the starting point for the field in the detail line. If this field is blank, the value is taken from the Spacing Between Columns option in the Parameter fill‑in.

+nn Specifies relative spacing, where nn is the number of columns to skip from the current position.
nnn Specifies absolute spacing, where nnn is the specific column number. When absolute spacing is used and nnn is to the left of the current position, the line is continued on the next line at the absolute position.
MAX Specifies absolute spacing, with the field right justified on the output line.
Lnn Specifies vertical spacing, where nn refers to the number of vertical spacing units. The default value for nn is 01. The number of lines in each vertical spacing unit is taken from the Spacing Between Lines option in the Parameter fill‑in.
P Specifies vertical spacing, positioning at the top of the next page.
Lnn and P must be separate entries with blank field names. In the following example, it is necessary to leave the second and fourth field name columns blank because of the value in the TAB column.
```
	FIELD NAME   ...   TAB
	X                   50
	                   L05
	Y                   50
	                     P
```
Leaving the field name blank when you specify Lnn in the TAB column is useful for skipping extra lines without producing a field on the report in that position.

Edit Pattern

Specifies the format in which the value of the field prints. An edit pattern is required when a numeric function or an arithmetic expression is specified and is optional for other data types.

For alphanumeric and numeric data items, the pattern entry is a sequence of any of the edit pattern symbols. In addition, an L in the first character of the edit pattern left justifies the result.

For date type data items, the entry is a sequence of characters representing the date pattern as defined in the $DATE function section in the Programming Reference Guide.

The edit pattern can take up to three lines of the Edit Pattern Field. However, the maximum length of an edit pattern is 30 characters. A semicolon in the name column is used as a continuation symbol. The semicolon must appear immediately following the field name to continue. Spaces found anywhere in the edit pattern are not suppressed.

Note: The numeric date functions such as $TODAY and $INTERNAL‑DATE require an edit pattern, not a date pattern. The report functions $RPT‑DATE and $RPT‑PAGE should not use a date or an edit pattern.

If this field is blank, the edit pattern is determined as follows:

If omitted and if an edit pattern for the field is specified in the dictionary facility, that edit pattern is used.
If an edit pattern is not found in the dictionary facility for this field, then the following rule is used:
- If the field is alphanumeric, left justify the value and blank fill.
- If the field is numeric, right justify the value and suppress leading zeros. If decimal places are present, replace with a period. If the value is negative, put a minus sign on the right‑hand side.
- If the field is a date field, use the default pattern for the site or the pattern set by a SET COMMAND DATEFOR command. For more information for an explanation of this command, see the Command Reference Guide.

Category and Meaning		Data in Source		Result

Pattern characters for alphanumeric data
x	Alphanumeric character Any other character represents itself	STATE AB1234	X(5) XXX‑XXX	STAT AB1‑234
Pattern characters for numeric data
L 9 Z * , / B 0 . ‑ ‑ ‑ + + + CR DB $ $ <> <>	Left‑justify before output Unsuppressed numeric digit Zero suppression Asterisk replacement Comma Slash Blank space Zero Decimal point Minus sign, fixed right Minus sign, fixed left Minus sign, floating Plus sign, fixed right Plus sign, fixed left Plus sign, floating Credit symbol, right Debit symbol, right Dollar sign, fixed Dollar sign, floating Encloses negative numbers in parentheses, fixed Encloses negative numbers in parentheses, floating	123 123 v12* lv23 002234v56 123083 123083 123 030v99 ‑23v45 23v45 ‑23v45 ‑v23 67v89 67v89 00v67 ‑25v00 25v00 ‑13v00 13v00 004v00 001v23 ‑23v45 ‑23v45	LZ(3),ZZ9 999 ZZZ.99 *9.99 ZZZ,ZZZ.99 99/99/99 99B99B99 99900 ZZZ.99 9(2).99‑ 9(2).99‑ ‑9(21).99 ‑‑.99 9(2).99+ +9(2).99 ++.99 9(2).99CR 9(2).99CR 9(2).99DB 9(2).99DB $Z9.99 $$$.99<9,999.99> $<,<<<.99>	123 123 .12 ***1.23 2,234.56 12/30/83 12 30 83 12300 30.99 23.45‑ 23.45 ‑23.45 ‑.23 67.89+ +67.89 +.67 25.00CR 25.00 13.00DB 13.00 $4.00 $1.23 (0,023.45) $ (23.45)

* Lowercase v represents the position of an assumed decimal point.

** You can condense edit patterns by using multipliers. For example, you can specify the expanded pattern ZZZZZZZZZ.99999 in the edit pattern as Z(9).9(5).

For a complete explanation of the rules summarized in this table, see the CODASYL COBOL Journal of Development.