Use FORM.DETAIL to:
FORM.DETAIL consists of detail variations that you define. You can create up to 99 variations, and each variation can correspond to conditions entered on FORM.CONDITIONS. Unless each condition is mutually exclusive, different detail variations can be displayed for the same data row.
FORM.DETAIL does not affect charts.
FORM.DETAIL A VAR 1 of 1 B Include Column Headings with Detail Heading? ===> YES C LINE D ALIGN E DETAIL HEADING TEXT ---- ------ ----+----1----+----2----+----3----+----4----+----5----+ 1 LEFT 2 LEFT *** END *** F New Page for Detail Block? ===> NO G Repeat Detail Heading? ===> NO H Keep Block on Page? ===> NO I Blank Lines After Block ===> 0 J Put Tabular Data at Line (Enter 1-999 or NONE) ===> 1 K LINE L ALIGN M DETAIL BLOCK TEXT ---- ------ ----+----1----+----2----+----3----+----4----+----5----+ 1 LEFT 2 LEFT *** END *** N Select Panel Variation? ===> YES 1=Help 2=Check 3=End 4=Show 5=Chart 6=Query 7=Backward 8=Forward 9= 10=Insert 11=Delete 12=Report OK, FORM.DETAIL is displayed. COMMAND ===> SCROLL ===> PAGE
You can create a new detail variation by entering a value one greater than the total number of variation panels over the current panel variation value. New panels must be added sequentially.
You can navigate to existing panel variations by entering the identifying value over the current panel variation value. You can also display different panel variations by entering the NEXT and PREVIOUS commands on the command line. (See NEXT and PREVIOUS for more information.)
Sections B through E specify text to be followed in a report by column headings specified on FORM.COLUMNS.
If you use the same LINE value for more than one line, those lines are joined according to the ALIGN value for the additional line or lines. Lines with the same LINE value overlay each other if they are longer than the report width, or if their ALIGN values conflict.
The previous line of text and the appended line of text must have the same LINE value if they are to be placed on the same line. If the report is not wide enough to accommodate the appended line of text, some of the text might be truncated.
If your installation supports DBCS data, see Names with double-byte characters.
Detail heading text always precedes column headings in a report. Detail headings consist of detail heading text, column headings, or both. Unless omitted, detail heading text and column headings constitute detail headings.
By default, a detail heading can extend from the left margin to the right margin of the report. Any text that extends beyond the right margin is not displayed or printed. You can alter the width by changing the report text width on the FORM.OPTIONS panel. If you do not explicitly specify a width, the right margin is determined by the width of the tabular data.
When printing a report, all the detail headings selected for the current row of data when the page heading is formatted are printed. If the number of lines for the detail heading exceed the number of available lines on the page, the excess detail heading lines are lost.
Detail headings can contain the following variable values:
ID NUMBER: &1 EMPLOYEE NAME: &2Can produce the following heading in a report:
ID NUMBER: 50 EMPLOYEE NAME: HANES
The &n value is the value of column n from the current row at the start of the new page. Detail headings for unconditionally selected variations are shown at the top of each screen in displayed reports. However, the value for &n appears only on the first screen of a displayed report. If you want to display the report online with page breaks, issue the DPRE command. See DPRE for more information on this command.
With this special syntax, the width of the substitution value is determined by the width specified by the associated column on the FORM.COLUMNS or FORM.MAIN panel.
For descriptions of &DATE, &TIME, and &PAGE, see page*** under BREAK1 HEADING TEXT.
Sections F through M specify report data that can be repeated in a report for each data row. This data, called a detail block, is the tabular data (if selected) and text associated with a single data line or a single detail line (for example, a row from a table).
The detail spacing option on the FORM.OPTIONS panel also affects the number of blank lines after detail block text.
This option can be used to mix text with tabular data. When a number is specified, tabular data overlays or combines with any detail block text on the same line.
If NONE is specified, tabular data is not formatted, but the column values can be included in the detail block text by using column substitution values.
The ALIGN values do not affect the horizontal placement of tabular data. To change the placement of tabular data, modify the column widths or indents on FORM.COLUMNS or FORM.MAIN. See D ALIGN on page*** for additional information.
If your installation supports DBCS data, see Names with double-byte characters.
By default, detail block text extends from the left margin to the right margin of the report. Any text that extends beyond the right margin is not displayed or printed. You can alter the width by changing the report text width on the FORM.OPTIONS panel. If you do not specify a width, the right margin is determined by the width of the tabular data.
Detail block text can contain literal text along with the following variable values:
DEPARTMENT: &3 EMPLOYEE NAME: &2Could produce the following line in a report:
DEPARTMENT: 20 EMPLOYEE NAME: SANDERS
In detail block text with a group summary report, the number of the data row for the last row in the group is printed.
For a description of &CALCid, see FORM.CALC.
For descriptions of &DATE, &TIME, and &PAGE, see page*** under BREAK1 HEADING TEXT.
In detail block text, the values for aggregations are based on the data values since the last break through the current row. Calculated values such as AVG and STDEV also are based on data values since the last break. For example, &AVG6 is the sum of column six (through the current row) divided by COUNT.
At the detail level, &SUM and &CSUM produce the same result. &SUM6 and &CSUM6 in the detail block text each produces the total value of column 6 through the current row.
If you use an aggregation variable with percent (PCT, TPCT, or TCPCT) in detail block text, and if you associate it with a column that has a D edit code, QMF formats the percent value in the detail block text as if it had an L edit code. Likewise, if you use the aggregation variable standard deviation in detail block text and associate it with a column that has a P or a D edit code, QMF formats the standard deviation in the detail block text as if it had an L edit code.
For more information, see the L code under Edit Codes for Numeric Data and Variables Used in Forms.
The following two choices allow you to selectively format your report. You can associate an entire panel of detail text and formatting options with a specific condition on the FORM.CONDITIONS panel (conditional formatting), or a specific data column that corresponds to a branch of tree data.