Panels › (DQEO0) Totaling Options

(DQEO0) Totaling Options

 =>
 ENTER THE DESIRED OPTIONS AND PRESS THE APPROPRIATE PFKEY
 --------------------------------------------------------------------------DQEO0
 DATAQUERY:  TOTALING OPTIONS
 -------------------------------------------------------------------------------
 
 QUERY NAME =>  ACTIVE-QUERY
 
 TOTALING OPTIONS
 
   _  DETAIL AND TOTALS             - PRODUCE REPORT WITH DETAIL AND TOTALS
   _  DETAIL ONLY                   - SUPPRESS ANY REQUESTED TOTALING
   _  TOTALS ONLY                   - PRODUCE THE REPORT WITH TOTALS ONLY
   _  TOTALS BY NAME                - ONLY USE THE ENTERED CONTROL-BREAK NAME
                                      ________________________________
   _  WHEN/DO RESULTS ONLY          - SUPPRESS ALL EXCEPT WHEN/DO RESULTS
   _  NO DETAIL                     - SUPPRESS DETAIL LINES on REPORT
 
 
 
 
 -------------------------------------------------------------------------------
 <PF1> HELP         <PF2>  RETURN     <PF3> EXECUTE

Description

When a DQL query with totals is executed with the video terminal as the destination, you can execute the query and change the totaling options as many times as you like when you view the report. With any report, if the query producing it is constructed to produce totals, you can select a valid totaling option for the current execution.

Action

Enter a character in the field next to the option you want for this execution. Press <PF3> EXECUTE to continue online execution.

Entry Fields

Use the space bar to remove entries and the keyboard keys to type different entries. Enter any character beside the selection of your choice. Be sure the panel contains an entry or selection for each category on the screen.

QUERY NAME =>

The name of the query or dialog named on the execution panel.

TOTALING OPTIONS

DETAIL AND TOTALS

All data and totals specified.

DETAIL ONLY

Suppress totals specified in query.

TOTALS ONLY

Do not show detailed data.

TOTALS BY NAME

Display totals only when named column data changes.

WHEN/DO RESULTS ONLY

Display only WHEN/DO results.

NO DETAIL

Display no detail lines, only WHEN/DO results or query totals.

When the Totaling Options panel is complete, you press a PF key to tell CA Dataquery what to do next.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help for panel.

<PF2> RETURN

Redisplays Online Execution panel. Retains selections.

<PF3> EXECUTE

1. Begins execution process.
2. If dialog, displays prompter panel for selection.
3. Displays execution messages.
4. Displays report if destination is video terminal.