OPEN DATABASE "db";

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

FIELD umsvjahr = umsatz1__3 DISPLAY AS MONEY(12, 0);
FIELD umsjahr  = umsatz1__2 DISPLAY AS MONEY(12, 0);
FIELD gruppe   = IF (umsvjahr >= 800000, "A",
                    IF (umsvjahr >= 250000, "B", "C"));

REPORT
   SELECT gruppe, kundnr, name1, umsvjahr
   FROM kunden
   WHERE umsvjahr <> 0
   ORDER BY 4 DESC
CALCULATE
   SUM(4) BREAK ON (1) PAGE
USING "man21a.frm";

REPORT
   SELECT 
      gruppe, COUNT(kundnr), SUM(umsvjahr), SUM(umsjahr)
   FROM kunden
   GROUP BY 1
CALCULATE
   SUM(2,3,4) BREAK ON REPORT
USING "man21b.frm";

EXIT;
