If a query you execute specifies totals, you can specify output variations on the TOTALING OPTIONS panel (DQE30) during execution. To display the panel, press <PF4> TOTALING OPTIONS during display of the Online Execution panel (DQE20).
=> ENTER THE DESIRED OPTIONS AND PRESS THE APPROPRIATE PFKEY --------------------------------------------------------------------------DQEO0 DATAQUERY: TOTALING OPTIONS ------------------------------------------------------------------------------- QUERY NAME => ACTIVE-QUERY TOTALING OPTIONS X 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
The following shows samples of each totaling option that is available on the TOTALING OPTIONS panel. It also shows the related output panel PF key and command for each option. Be sure to include hyphens in commands where required. Typing a hyphenated command as two words can produce unpredictable results.
Shows all items on the report. For example:
SALES-REP CUSTOMER YEAR-TO-DATE
ID NAME SALES
-------- ------------------------------ ------------
52733 UNITED ATLANTIC SHARES 452.00
TOTAL CITY CHARLOTTE
* 452.00
52733 SUN DIAL CITRUS GROWERS 21101.50
52733 SUN DIAL CITRUS GROWERS 21101.50
52733 SUN DIAL CITRUS GROWERS 21101.50
TOTAL CITY LOS ANGELES * 63304.50
The command for this presentation is DETAIL.
Shows no data rows. Shows PRINT statement totals and function results. For example:
TOTAL CITY NEW YORK
* 12000.00
* GRAND TOTAL
* 75756.50
AVERAGE YEAR-TO-DATE SALES PER CUSTOMER 0007575.65
The command for this presentation is NO-DETAIL.
Shows no data rows and no function results. For example:
YEAR-TO-DATE
CITY SALES
--------------- ------------
CHARLOTTE 452.00
LOS ANGELES 63304.50
NEW YORK 12000.00
* GRAND TOTAL
75756.50
The command for this presentation is TOTALS.
Shows no totals or column function results. Detail lines only. For example:
SALES-REP CUSTOMER YEAR-TO-DATE ID NAME SALES -------- ------------------------------ ------------ 52733 UNITED ATLANTIC SHARES 452.00 52733 SUN DIAL CITRUS GROWERS 21101.50 52733 SUN DIAL CITRUS GROWERS 21101.50 52733 SUN DIAL CITRUS GROWERS 21101.50 52733 INTERNATIONAL BANK CORP. 2000.00 52733 INTERNATIONAL BANK CORP. 2000.00 52733 INTERNATIONAL BANK CORP. 2000.00 52733 INTERNATIONAL BANK CORP. 2000.00 52733 INTERNATIONAL BANK CORP. 2000.00 52733 INTERNATIONAL BANK CORP. 2000.00
The command for this presentation is NO-TOT.
Shows only results of WHEN/DO statements. For example:
AVERAGE YEAR-TO-DATE SALES 0007575.65
The command for this presentation is WHEN-ONLY.
The query executed specifies the kinds of totals the query produces and which data is totaled. During output presentation, you can suppress the totals or the detail if totals are specified in the query/dialog report format. You cannot suppress the results of other calculations.
|
Copyright © 2014 CA.
All rights reserved.
|
|