OPEN DATABASE "db";

SET DATE = "%d.%m.%y";

FIELD prevsales = turnover__3 DISPLAY AS MONEY(12, 0);
FIELD ytdsales  = turnover__2 DISPLAY AS MONEY(12, 0);
FIELD groups    = IF (prevsales >= 800000, "A",
                    IF (prevsales >= 250000, "B", "C"));

REPORT
   SELECT groups, custno, name1, prevsales
   FROM customers
   WHERE prevsales <> 0
   ORDER BY 4 DESC
CALCULATE
   SUM(4) BREAK ON (1) PAGE
USING "man21a.frm";

REPORT
   SELECT 
      groups, COUNT(custno), SUM(prevsales), SUM(ytdsales)
   FROM customers
   GROUP BY 1
CALCULATE
   SUM(2,3,4) BREAK ON REPORT
USING "man21b.frm";

EXIT;

