Group footer

rbuser

I have the following SQL:

SELECT Type, Name, Code, Price, Weight, Repaired
FROM Machine

Now I create a group so that
Type <-- group header
Name, Code, Price, Weight, Repaired <-- detail band


I want to show the group footer has the number of repaired machines in each
group, how do I do that ?
ie.
Type <-- group header
Name, Code, Price, Weight<-- detail band
Number of repaired machine: <-- group footer

nicocizik

Hi,

Try placing a DBCalc component inside the group footer set to calculate the
sum of the "Repaired" field. Then set the ResetGroup property of the DBCalc
component to the proper group.

--
Regards,

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