Getting a Report › Using DQL Mode Reporting › Changing the Format of DQL Mode Total Output › WHEN/DO Totals Sample Output

WHEN/DO Totals Sample Output

Totals Using Only WHEN/DO Results

 =>

10/03/11                         CA DATAQUERY                         PAGE 1
13:41:44                         TOTAL SALES                    WHENS-ONLY


  AVERAGE YEAR TO DATE SALES PER CUSTOMER 0007402.48

The previous example shows a typical report when only WHEN/DO is specified on the TOTALING OPTIONS panel or with the WHEN command on the output panel. The query must contain a WHEN/DO statement.

NO-DETAIL Totals Sample Output

 =>

11/12/11                         CA DATAQUERY                         PAGE 1
15:10:43                         TOTAL SALES                      NO-DETAIL



  TOTAL CITY CHARLOTTE
                                            *    452.00

  TOTAL CITY LOS ANGELES
                                            *  63304.50

  TOTAL CITY NEW YORK
                                            *  12000.00

* GRAND TOTAL
                                            *  75756.50

  AVERAGE YEAR TO DATE SALES PER CUSTOMER 0007575.65

The previous example shows the results when NO-DETAIL is selected on the TOTALING OPTIONS panel or typed as a command.