Panels › (DQHL0) Report Column Format Definition

(DQHL0) Report Column Format Definition

 =>
 
 --------------------------------------------------------------------------DQHL0
 DATAQUERY:  REPORT COLUMN FORMAT DEFINITION     QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Select the type of editing desired for each numeric column on your report.
 Place any character in the column that represents the edit format needed.
 Defaults are provided and can be modified.
   Column 1:   12345.678  Column 3: 0,012,345.678  Column 5: Datadictionary edit
   Column 2:  12,345.678  Column 4:   $12,345.68
 -------------------------------------------------------------------------------
  TABLE NAME/COLUMN NAME              |   1   |   2   |   3   |   4   |   5
 -------------------------------------------------------------------------------
                                      |       |       |       |       |
                                      |       |       |       |       |
                                      |       |       |       |       |
                                      |       |       |       |       |
                                      |       |       |       |       |
                                      |       |       |       |       |
                                      |       |       |       |       |
                                      |       |       |       |       |
 -------------------------------------------------------------------------------
 <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 Report Column Format Definition panel appears if any numeric column is reported in the query output. It allows you to select a format for the appearance of the numeric data or accept the default.

Action

Enter a character in the column next to each column for an alternate edit pattern that you want to use and space over the default selection or press Enter or <PF4> CONTINUE to accept the default.

Display Fields

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

QUERY NAME:

Name you assigned this query.

TABLE NAME/ COLUMN NAME

The table and column names for each numeric column you selected for the report.

Columns

Refer to the following for a discussion of each column on this panel.

Column 1

Suppress leading zeros, no commas, decimal places as required to display numeric column.

Column 2

Suppress leading zeros, use commas and decimal places as required.

Column 3

Show leading zeros, use commas and decimal places as required.

Column 4

Using floating dollar sign, commas, and two decimal places.

Column 5

Use the Datadictionary edit pattern assigned to the column/key, if one exists. The text display for a column shows the Datadictionary edit pattern, if one exists.

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 Heading Definition (DQHK0) panel.

<PF4> CONTINUE

Displays the next Guided Query panel when this one is complete. (Returning to this panel from a later panel will require that you redisplay any entry to save it again.)

<PF5> EXTEND COLUMN

Displays the extended column definition for key/column selected.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.