I have generated a report that includes subtotals and a grand total line. Everything was fine until the user requested a Total # of records value added to the grand total line. I have been struggling trying to find a way to do this. My mind says that this should be a simple task, but it's not clicking. Any help would be appreciated.

This message has been edited. Last edited by: James at WI,

Hi James,
The following comes to mind:
Use a define such that at the table or matrix is built each record gets an integer count of one and at the break disply a sum of that count.
DEFINE MYFILE
RECD_CNT/I9 = 1;
END
This, essentially, builds a new field in each extracted record containing the value one.
Then you can do with it whatever turns you on.
HTH

Better, I now have a new column that has a 1 on every detail row, but at least the total (and subtotal) line has the correct value. Do you know if there is anyway to stop the display of the detail value but maintain the totals?

Thanks

What you can do is do the count first in a hold pass
then read the number into an amper value
and put that in the footer

James,

How about using subfoot to print the total lines? If that is acceptable then the below example will help you. Here the Define field "CNT" is not diplayed in the table, however the sum of CNT is displayed in the subfoot.

DEFINE FILE CAR
CNT\I4=1;
END

TABLE FILE CAR
SUM
SALES
BY CNT NOPRINT
BY COUNTRY
BY CAR
ON CNT SUBFOOT
"Total Lines <ST.CNT>"
ON TABLE PCHOLD FORMAT HTML
END

Absolutely perfect. thanks for all the help.