groups

rbuser

Hello

i have an invoice with a footer where the calcs of totals are made. In this
invoice i use groups to take some things together. Before i had groups i did
set the printcount of the detailband to prevent that more records where
printed then could fit on a page.
Now that i have groups i don't now how high i can set the printcount because
i don't know the number of groups (and groupheaders). So how can i set the
max height of the total detailband ?

Met vriendelijke groet, With kind regards,


Frank Beerens

nicocizik

Hi Frank,

Unfortunately there is no way to tell how many groups will be printed
without doing some pre-processing of some sort. One option would be to
create a summary query that returns a count of the grouping field,
essentially giving you a record per group. Using this you could determine
how many groups there are and how many details there are per group and size
your bands accordingly.

SELECT orders.CustNo, COUNT(*) CustCount
FROM orders
GROUP BY orders.CustNo
ORDER BY orders.CustNo


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com