Panels › (DQHO0) Column Function Legends

(DQHO0) Column Function Legends

 =>
 
 --------------------------------------------------------------------------DQHO0
 DATAQUERY:  COLUMN 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 | TABLE NAME/COLUMN NAME           | LEGEND
 -------------------------------------------------------------------------------
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
     |                                  |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

In DQL Mode, the optional Guided Query Column Function Legends panel lists each column function you specified with the Column Definition (DQHI0) panel. This panel allows you to 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. An introduction to this panel appears in the CA Dataquery User Guide.

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.

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.

TABLE NAME/ 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.

<PF5> EXTEND COLUMN

Displays the extended column definition for key/column selected by cursor position.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.