Hey all,

I've been looking for other threads on this, and can't seem to find one. I swear there was something on this subject at some point.

Does anyone here know if there is a way to grab the column total value and use it in the header of a report?

Any help is much appreciated!

Thanks in advance!

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

Does this work for you?

TABLE FILE CAR
PRINT *
ON TABLE SUBHEAD
"TOTAL SEATS <TOT.SEATS"
END

That seems to work. Thanks bug!

Although, when I run the report while adding a total along the bottom of the report, the word "TOTAL" on the left is getting its own line, while the total values are on their own line (a second line). Is there a way to fix this so that it's all on one line if you plug in a column total or summarize line at the bottom of the report?

My code:

TABLE FILE CAR
PRINT *
ON TABLE SUBHEAD
"TOTAL SEATS <TOT.SEATS"
ON TABLE COLUMN-TOTAL
END

Thanks again!

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

Well, you need to have atleast one column in sortfield and that makes sense too. Or use SUBFOOT

TABLE FILE CAR
PRINT *
BY COUNTRY
ON TABLE SUBHEAD
"TOTAL SEATS <TOT.SEATS"
ON TABLE COLUMN-TOTAL
END

Thanks for your insights. We found that out ourselves this paast Friday. We also noticed if we do the following, it will correct the total line as well. We just won't be able to tag it:

ON TABLE COLUMN-TOTAL AS ''