Totals Using Only Totals by Name - (STATE)
CA DATAQUERY TOTAL SALES STATE YTD-SALES ----- ------------- GA 3,566,223.00 MD 776,500.00 * GRAND TOTAL 4,342,723.00
The previous sample output shows only the totals produced for each state, which is specified as a control break column in the query. The report identifies the control break column (STATE) and the total (YTD-SALES) calculated for each control break. The following example shows the output produced if CITY is the name used on the TOTALING OPTIONS panel (assuming CITY is a control break column).
Totals Using Only Totals by Name - (CITY)
CA DATAQUERY TOTAL SALES STATE CITY YTD-SALES ----- --------------- ------------- GA ATLANTA 3,566,223.00 MD BALTIMORE 372,100.00 MD GERMANTOWN 286,550.00 MD TOWSON 117,850.00 * GRAND TOTAL 4,342,723.00
If you choose the control break name option, the report contains only the totals for a specific control break column contained in the query. No detail lines are included in this report. The sample output shows only the totals produced for each city, which is specified as a control break column in the query. The report identifies the control break column (CITY) and the total (YTD-SALES) calculated for each control break.
To find out which columns are designated as control breaks, you can display the query with the EDIT query-name command. Look for column names in the SORT statement that are enclosed in parentheses.
|
Copyright © 2014 CA.
All rights reserved.
|
|