DET.SUP

DET.SUP, DET-SUPP

Top  Previous  Next

 

The DET.SUP keyword (synonym DET-SUPP) suppresses reporting of detail lines, leaving only page and column headers, totals, footers and the final record count.

 

 

Format

 

DET.SUP

 

 

The DET.SUP keyword removes all detail lines from a report. It allows easy reporting of totals without the data that contributed to the totals.

 

When a query uses both DET.SUP and breakpoints, any column for which no breakpoint is defined and no arithmetic field qualifier is in use will show the value of that field for the last record processed within that breakpoint group. This is probably only meaningful when the value of the field is the same for all records in the breakpoint group.

 

When used with report styles (see the STYLE option), subtotal lines will be reported using the detail line style.

 

 

Example

 

The command

 

LIST SALES BY REGION BREAK.ON REGION SALESMAN TOTAL ORDER.VALUE

 

would produce a display such as that below.

 

LIST SALES BY REGION BREAK.ON REGION SALESMAN TOTAL ORDER.VALUE        Page 1

SALES..... REGION  SALESMAN  ORDER VALUE

19887       North   Roberts        279.40

19859       North   Sharp          384.43

19858       North   Sharp          845.50

19845       North   Harris         234.53

           **                -----------

           North                 1743.86

 

19866       South   Abbott         465.31

19886       South   Abbott         397.23

19830       South   Smith          324.39

           **                -----------

           South                 1186.93

 

                             ===========

                                 2930.79

7 records listed.

 

 

Adding the DET.SUP keyword and omitting the salesman changes this report to be as below.

 

LIST SALES BY REGION BREAK.ON REGION TOTAL ORDER.VALUE DET.SU   Page 1

REGION  ORDER VALUE

North       1743.86

South       1186.93

       ===========

           2930.79

7 records listed.