I have a report for which in addition to totaling units, sales dollars, etc. I wish to show a count in the subtotal and grand total lines for how many lines make up each grouping. I have created a DEFINE variable equal to 1 and include it as part of my detail level output so that when a subtotal occurs, it indicates the count for that section. However, I don't really like all the 1's showing on each line and am wondering if anyone knows a way to suppress the printing of the line-level values but still show the total. I know (believe) I need a column in the output for the define field and that's fine - I don't care if it takes up some horizontal space on the report even if no value shows at the line level, just shows in that column at the subtotal and grand total level. I know I can use a SUBFOOT and show the value but I really would like the value to appear on the same line as other totals. Thanks for any suggestions!

This message has been edited. Last edited by: <Kathryn Henning>,

A multi verb report should answer your need:

TABLE FILE CAR
SUM CNT.MODEL AS 'NB CAR,PER COUNTRY'
BY COUNTRY
SUM CNT.MODEL AS 'NB MODEL,PER CAR'
BY COUNTRY
BY CAR
END

So you need to SUM your counter in the first part then add the rest of your displayable fields in the other.

Thanks! I was not aware of multi verb.