Panels › (DQF80) Report Format - Function Legends

(DQF80) Report Format - Function Legends

 =>
 
 --------------------------------------------------------------------------DQF80
 DATAQUERY:  REPORT FORMAT - FUNCTION LEGENDS       QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Enter a legend to be displayed with the result of the indicated function
 during control break processing.
 Defaults are provided and can be modified.
 -------------------------------------------------------------------------------
 FNC | COLUMN NAME                      | LEGEND
 -------------------------------------------------------------------------------
 AVG | AVERAGE MONTHLY EXPENSES         |
     |                                  |
 MIN | MINIMUM EXPENDITURES             |
     |                                  |
 MAX | MAXIMUM EXPENDITURES             |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> NOT USED       <PF6> NOT USED       <PF7> BACKWARD   <PF8> FORWARD

Description

This SQL Mode report formatting panel lists each column function specified for this report. Here, you can assign a legend to the printed results of each column function. The legend you define appears next to the function results when they appear on the query output.

Action

Accept the default legend or type a new one over it. You can use a heading substitution string in the Legend field. If you want the current value of the control break printed within this legend, you can include a site-specified heading substitution string like && in the legend. See the System Profile panel in Topic Help to learn what characters are used at your site as a heading substitution string. Press Enter or <PF4> CONTINUE to go on to the next Guided Query panel.

Display Fields

Refer to the following for explanations of the display fields intended to contain variable data.

QUERY NAME:

Name you assigned this query.

COLUMN NAME

Column names for each numeric column selected for the

Columns

Refer to the following for explanations of the columns on this panel.

FNC

Function assigned to the column listed at right.

AVG

Average value of the column at calculation.

MAX

Highest value found in the column at calculation.

MIN

Lowest value found in the column at calculation.

CNT

Number of times this column was printed at calculation.

SUM

The sum of the values in this column at calculation.

COLUMN NAME

Names of columns to which you assigned a column function to be calculated at control breaks or end of report.

LEGEND

Enter a 1- to 38-character legend to be printed when functions are calculated and results are printed. You can use a heading substitution string in the Legend field. If you want the current value of the control break printed within this legend, you can include a site-specified heading substitution string like && in the legend. See the System Profile panel in Topic Help to learn what characters are used at your site as a heading substitution string.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Returns to Report Column Format Definition (DQHL0) panel.

<PF4> CONTINUE

Displays the next Guided Query panel.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.