Most of the values that I am trying to place in the subfooting are not appearing. I believe it may have to do with the values not being ordered by 'by' in the former section of the report.

How can I have the subfooting display all of the values that I would like it too?

Anyone else run across this problem?

Thanks for the help!

This message has been edited. Last edited by: Charles Richards,

I think I may have figured this out, I believe you have to make a column and set it to by and invisable then they appear in the subfooting. So just incase anyone else was having the same issue.

Its a work around though

Anyone know how to get the values to ahow up even without having them ordered by 'by'?

This message has been edited. Last edited by: Charles Richards,

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON COUNTRY SUBFOOT
"<SEATS <CAR <MODEL"
END

You will only get one SUBFOOT per COUNTRY, with values from one data row(the first or the last within the BY statement - who knows).

You may wish to post your code if you want a better explanation.