Purpose
Use the TOTALS command to display only the PRINT command column totals defined in the query or dialog. TOTALS suppresses detail lines and WHEN/DO results.
When to Use It
Use this command in DQL Mode to display only PRINT statement control break and end of report totals.
Syntax
|
Enter |
With |
When You Want to: |
|---|---|---|
|
TOTALS |
No operand |
Suppress detail lines and WHEN/DO results in an output display. |
Example
=> TOTALS 01/03/2010 DATAQUERY SAMPLE PAGE 1A 16:53:20 DETAIL CUSTOMER PHONE SALESMAN NAME CITY STATE NUMBER ID ------------------------------ --------------- ----- ---------- -------- UNITED ATLANTIC SHARES CHARLOTTE NC 7045554852 52733 TOTAL ACTIVITY/MONTH 02 AVERAGE SALE 0000452.00 INTERNATIONAL BANK CORP. NEW YORK NY 2125559889 52733 TOTAL ACTIVITY/MONTH 03 -------------------------------- MORE .... --------------------------------- => <PF1> HELP <PF2> RETURN <PF3> TOTALS ONLY <PF4> DETAIL <PF5> NO TOTALS <PF6> STATS <PF7> BACKWARD <PF8> FORWARD <PF9> NOT USED <PF10> NOT USED <PF11> LEFT <PF12> RIGHT
Result
=> 01/05/2010 DATAQUERY SAMPLE PAGE 1 16:53:20 TOTALS-ONLY ACTIVITY YEAR TO DATE MONTH SALES -------- ------------ 02 452.00 03 2000.00 04 341924.50 06 5000.00 08 0.00 09 0.00 11 1030318.34 * GRAND TOTAL 1379694.84 -------------------------------- LAST PAGE ------------------------------------ <PF1> HELP <PF2> RETURN <PF3> TOTALS ONLY <PF4> DETAIL <PF5> NO TOTALS <PF6> STATS <PF7> BACKWARD <PF8> FORWARD <PF9> NOT USED <PF10> NOT USED <PF11> LEFT <PF12> RIGHT
|
Copyright © 2014 CA.
All rights reserved.
|
|