decending order sub-report

[BatmanMR287]

I have a query that returns six totals. The problem is I need to display each total vertically from largest to least. If they were in the same column I could easy do this. Since they are not I don't know how to make a sub-report that shows them vertically from largest to least. The totals will change depending on the district so it has to be able to sort itself for the report.
All tables are a relational database. There isn't a way to change any internal structure.


Any ideas?

[BatmanMR287]

Nevermind. I found a way to populate a temp table perfectly so they are all in the same column and can be filtered and printed correctly.

[June7]

Should be able to accomplish with a UNION query as the subreport RecordSource. Why are these totals in 6 fields instead of 1?