Panels › (DQF70) Report Format - Column Format

(DQF70) Report Format - Column Format

 =>
 
 --------------------------------------------------------------------------DQF70
 DATAQUERY:  REPORT FORMAT - COLUMN FORMAT       QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Select the type of editing desired for each numeric column on your report.
 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 5: E12,345.68
   Column 2: 12,345.678  Column 4:   $12,345.68   Use only for euro support
 -------------------------------------------------------------------------------
 COLUMN NAME                      |   1   |   2   |   3   |   4   |   5
 -------------------------------------------------------------------------------
  AVERAGE WEEKLY EXPENSES         |   _   |   _   |   _   |   _   |   _
  AVERAGE WEEKLY INCOME           |   _   |   _   |   _   |   _   |   _
                                  |   _   |   _   |   _   |   _   |   _
                                  |   _   |   _   |   _   |   _   |   _
                                  |   _   |   _   |   _   |   _   |   _
                                  |   _   |   _   |   _   |   _   |   _
                                  |   _   |   _   |   _   |   _   |   _
                                  |   _   |   _   |   _   |   _   |   _
 -------------------------------------------------------------------------------
 <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 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 assigned this query.

COLUMN NAME

The table and column names for each numeric column 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. Numbers are rounded upwards to the nearest cent.

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

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.