Panels › (DQF40) Report Format - Control Breaks

(DQF40) Report Format - Control Breaks

 =>
 
 --------------------------------------------------------------------------DQF40
 DATAQUERY:  REPORT FORMAT - CONTROL BREAKS        QUERY NAME:
 ------------------------------------------------------------------------------
 The named columns were used to order rows in the table resulting from the
 execution of this SQL query.  Place any character under "CONTROL BREAK"
 to select that column as a control break.  Place any character under "NEW
 PAGE" for a column selected for control break to get a new report page.
 -------------------------------------------------------------------------------
                                  |SORT SEQUENCE |CONTROL | NEW
 COLUMN NAME                      |ASCEND/DESCEND| BREAK  | PAGE
 -------------------------------------------------------------------------------
                                  |              |        |
                                  |              |        |
                                  |              |        |
                                  |              |        |
                                  |              |        |
                                  |              |        |
                                  |              |        |
                                  |              |        |
 -------------------------------------------------------------------------------
 <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 allows you to designate a column named in an ORDER BY statement as a control break during report generation.

Action

Specify a sorting sequence and whether you want the column to be a control break or generate a new page.

Display Fields

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

QUERY NAME:

The name of this query.

COLUMN NAME

The named columns used to order rows in the table.

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

Exits the current panel.

<PF4> CONTINUE

Goes to the next report formatting panel.

<PF7> BACKWARD

Scrolls list backward one page.

<PF8> FORWARD

Scrolls list forward one page.