Listing Group Totals

[RWahlert]

I am writting a purchase order status report, by department, based on a Crystal Query. One of the specs calls for a summary page at the end of the report that will list the totals for each department. I am currently goruping by department and can calclulate the total for each group but do not know how to store the value that is calculated so that I can display that value with all the other department totals.

Any thoughts would be appreciated.

 

[synapsevampire]

Crystal Queries are ill advised.

Try using a Cross-Tab to supply the summary in the report footer.

Place the department in the rows, and the value in the field to summarize.

-k

 

[RWahlert]

Sadly a cross tab will not fit the bill. I am using a Crystal query because I need to perform a union between two select statements. In essence I am pulling data from two goups of unlated tables: PO Open and PO history.

Why do you dislike Crystal Querys?