Following are examples of reports created by executing the same query and altering only the totaling specifications.
Detail and Totals Sample Output
CA DATAQUERY TOTAL SALES SLMN-ID NAME YTD-SALES ------- ------------------------------ ------------- 00795 NATIONAL HARRIS CORPORATION 7,950.00 23615 M.A.C. SAVINGS 236,150.00 34222 CANNON TOOLS CO 3,322,123.00 TOTAL CITY ATLANTA *3,566,223.00 AVERAGE SALES FOR ATLANTA 1,188,741.00 TOTAL STATE GA *3,566,223.00
Selecting the detail and totals option for your report at execution produces a report containing all output data, including details, calculation results and totals, requested by the query. In the above sample output, detail lines are produced which contain the sales representative's ID (SLMN-ID), the name of the company (NAME) and the year-to-date sales (YTD-SALES) to that company. The query which produced this report specifies CITY and STATE as control break columns. This means a total of year-to-date sales is calculated for each city included in the report, such as in the line identified as TOTAL CITY ATLANTA. Then when the state changes, a sum of all sales from all cities is presented.
Detail Only Sample Output
CA DATAQUERY TOTAL SALES SLMN-ID NAME YTD-SALES ------- ------------------------------ ------------- 00795 NATIONAL HARRIS CORPORATION 7,950.00 23615 M.A.C. SAVINGS 236,150.00 34222 CANNON TOOLS CO 3,322,123.00 00655 WEST LIFE INSURANCE 6,550.00 11400 MALIRY ENTERTAINMENT INDUSTRY 114,000.00 25155 CHESTERSON-KIDD INC 251,550.00 28655 FOXBORRO PETRO-CHEMICAL 286,550.00 11785 PARKER REPUBLIC CONSOLIDATED 117,850.00
Selecting the detail only option (<PF5> NO-TOTALS on output display) produces a report which suppresses totals, including those produced by control break columns. This report includes calculation results requested by the query, except for totals. The above sample output shows only the detail lines, which includes the sales representative's ID (SLMN-ID), company name (NAME) and the year-to-date sales (YTD-SALES) to that company.
Totals Only Sample Output
CA DATAQUERY TOTAL SALES STATE CITY YTD-SALES ----- --------------- ------------- GA ATLANTA 3,566,223.00 GA 3,566,223.00 MD BALTIMORE 372,100.00 MD GERMANTOWN 286,550.00 MD TOWSON 117,850.00 MD 776,500.00 * GRAND TOTAL 4,342,723.00
If you select the totals only option, the report contains only the totals requested by the query. No detail lines are included in this report. The above sample output shows only the totals produced after you execute the query.
|
Copyright © 2014 CA.
All rights reserved.
|
|