Panels › (DQF60) Report Format - Column Headings

(DQF60) Report Format - Column Headings

 =>
 
 --------------------------------------------------------------------------DQF60
 DATAQUERY:  REPORT FORMAT - COLUMN HEADINGS     QUERY NAME: TESTEXEC
 -------------------------------------------------------------------------------
 You may enter alternate headings for any column on the report.
 Defaults are provided and can be modified.
 -------------------------------------------------------------------------------
 COLUMN: ID                              LINE1: ID
                                         LINE2:
 
 COLUMN: NAME                            LINE1: NAME
                                         LINE2:
 
 COLUMN: DEPT                            LINE1: DEPT
                                         LINE2:
 
 COLUMN: JOB                             LINE1: JOB
                                         LINE2:
 
 
 -------------------------------------------------------------------------------
 <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 lets you define your own titles for each column printed in your query output. If you do not define a title, CA Dataquery supplies one using the Datadictionary alternate heading. If no Datadictionary alternate heading exists, the column name is used. The default names are shown in the LINE1: input columns for each column selected for the report.

Action

Enter a one or two line title for each column heading in the columns provided for each column, typing over the default column names, or press Enter or <PF4> CONTINUE to go on to the next 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:

Contains the name of a column you selected to appear in the report. Temporary results are not shown since you assign them a name yourself when you create them.

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the TAB and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

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 Column Definition (DQHI0) panel.

<PF4> CONTINUE

Displays the next 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 the next panel, if any.