Panels › (DQF90) Report Format - Function Format

(DQF90) Report Format - Function Format

 =>
 
 --------------------------------------------------------------------------DQF90
 DATAQUERY:  REPORT FORMAT - FUNCTION FORMAT     QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Select the type of editing desired for each function result.
 Place any character under the number that represents the edit format needed.
 Defaults are provided and can be modified.
   Column 1:  12345.678  Column 3: 0,012,345.678
   Column 2: 12,345.678  Column 4:   $12,345.68
 -------------------------------------------------------------------------------
 FCN | COLUMN NAME                      |   1  |   2  |   3  |   4  |
 -------------------------------------------------------------------------------
 MIN |  LEAST AMOUNT SPENT              |      |      |      |      |
 MAX |  LARGEST AMOUNT SPENT            |      |      |      |      |
 AVG |  AVERAGE COSTS                   |      |      |      |      |
     |                                  |      |      |      |      |
     |                                  |      |      |      |      |
     |                                  |      |      |      |      |
     |                                  |      |      |      |      |
     |                                  |      |      |      |      |
 -------------------------------------------------------------------------------
 <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 permits you to change the display characteristics (numeric format or edit pattern) of any numeric data that appears in the columns that display the result of calculations selected as column functions. The default is indicated by an X in a column next to each function selection.

Action

Select a numeric format for each column function result by placing a character in the numbered column on this panel that represents the format you want the calculation result to have in the output.

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 report.

Columns

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

FCN

Function assigned to the column listed at right.

AVG

Average value of the column at calculation.

MAX

Highest value in the column at calculation.

MIN

Lowest value in the column at calculation.

CNT

Number of times this column was printed at calculation.

SUM

Sum of values in this column at calculation.

COLUMN NAME: Name of each column to which you assigned a column function to be calculated at control breaks or report end.

Column 1

No leading zeros, no commas, decimal places as required to display number.

Column 2

No leading zeros, comma separators, decimal places as required to display number.

Column 3

Leading zeros, comma separators, decimal places as required to display number.

Column 4

Floating dollar sign ($), comma separators, two decimal places.

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

Exits panel or step.

<PF4> CONTINUE

Accepts the current entries and displays the next panel. (Returning to this panel from a later panel will require that you redisplay any entry to save it again.)

<PF7> BACKWARD

Displays the previous panel, if any.

<PF8> FORWARD

Displays the next panel, if any.