I need to know how to get all my columns to show up in one column. I do not want my totals to go across on one row. Can anyone help?

Thanks...

Not at all sure what you mean. Do you want to sum multiple numeric database columns into one report column, or is it something else?

Would you like to see your column totals in a footing?

Say your columns are JAN.... DEC and

your footing would be

JAN TOTAL
.
.
.
DEC TOTAL

where TOTAL represents the sum of the column?

jimster06,

That is exactly what I want. Then, I would like a column next to it with another set of totals. Do you have any ideas?

Thanks...

Slim,

Could this help"

  
-* File slim1.fex
TABLE FILE CAR
PRINT SALES RCOST DCOST
BY COUNTRY 
ON COUNTRY SUBFOOT
"TOTAL FOR <COUNTRY"
"SALES <ST.SALES"
"RETAIL <ST.RCOST"
"DEALER <ST.DCOST"
" "
ON TABLE SET STYLE *
TYPE=SUBFOOT, HEADALIGN=BODY, $
ENDSTYLE
END

Thanks Danny!

That seemed to work. You wouldn't happen to know how to get another column next to it do the same thing would you?

Thanks Again...

Slim,
Of course: anything is possible in WF! But what do you mean by "the same thing"?

Danny,

I want 8 additional columns that total off of a particular database category/value. Right now, I have 1 column with totals. Do you have any ideas?

Thanks...

Slim,
It is not very clear what you want. An example could help. Nonetheless see the following. I suppose that if you have other data you can replace some of the subtotaled fields.

  
-* File slim1.fex
TABLE FILE CAR
PRINT SALES RCOST DCOST
BY COUNTRY
ON COUNTRY SUBFOOT
"TOTAL FOR <COUNTRY"
"SALES <ST.SALES<ST.SALES<ST.SALES"
"RETAIL <ST.RCOST<ST.RCOST<ST.RCOST"
"DEALER <ST.DCOST<ST.DCOST<ST.DCOST"
" "
ON TABLE SET STYLE *
TYPE=SUBFOOT, HEADALIGN=BODY, JUSTIFY=RIGHT,$
TYPE=SUBFOOT, ITEM=1, JUSTIFY=LEFT,$
ENDSTYLE
END

Thanks Danny!

That's exactly what I was wanting. Sorry I was not clear.

Thanks...