All,

TABLE FILE CAR
PRINT SALES
BY COUNTRY
BY CAR
ON TABLE RECOMPUTE
END

I need to know, how to get a grand total for each car?

This message has been edited. Last edited by: Kerry,

nsk,

you can do this very easily using the GUI. Open up the report painter and try it in there by looking at Subtotals and then look at the code. That will give you your answer.

Eric

TABLE FILE CAR
PRINT SALES
BY COUNTRY
BY CAR SUBTOTAL

END

Eric is correct. Here is the code that might be generated. Uber easy.

Note: My original post had copied the original code from the poster. I have corrected it.

This message has been edited. Last edited by: GinnyJakes,

Change the ON TABLE RECOMPUTE to ON CAR SUB-TOTAL.

Make sure you use the hyphenated version of SUB-TOTAL and not SUBTOTAL.

Or did you mean totals only on Car and Report and not on Country? If so use the non-hyphenated version

T

Well, this was elementary, straight out of the book.
However, maybe the real question that "nsk" wanted to ask is:

  
TABLE FILE CAR
PRINT SALES
BY CAR SUBTOTAL
BY BODYTYPE
END

and also get at the end a list of BODYTYPEs with BODYTYPE totals for the whole file.
Or am I way off?