Total in footers

rbuser

Hi, i want to know if this is possible and how:

- Group 1:
Customer code (Can be a lot)
- Group 2:
Order number for each customer (Can be a lot)
- Detail:
Item 1 Quantity of Item 1
Item 2 Quantity of Item 2
...
Item n Quantity of Item n
- Footer for Group 1
Total Quantity for Item 1
Total quantity for Item 2
...
- Report summary
Total Quantity for Item 1
Total quantity for Item 2

Thanks a lot
--
Guillermo Castaño Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
GuillermoC@GrupoMillennium.com
http://www.GrupoMillennium.com

digitalmetaphors

Hi Guillermo!

I've attached an example.

The best approach seems to be to use SQL to do the counting. The example
actually contains three queries: one for the main report, one for the item
type count for each customer and one for the item type count for the whole
report. I used a subreport in the group footer and in the summary to print
the results of the SQL.

Originally I linked the second query to the first query via the DataSource
property and a parameter on the CustNo field. However, the BDE is just too
slow for this technique, so I ended up linking the pipes instead. This is
good technique (it's much faster), but you have to be careful to order the
detail query the same as the master query...

Cheers,

Tom Ollar
Digital Metaphors Corporation