REPORT WITH SUMMARY ON TOP

rbuser

??Need to have a report with that group the total at the top based on 2 field
qty class1 class2 description price priceXNumi
2 1 2 xyz 10 20
3 1 3 xxx 1 3
2 1 2 yyy 2 4
2 2 2 ddd 1 2
4 2 2 ccc 5 40

Need to group and have total at the top of the details
grouping by class1 and class2
select sum(qty), class1,class2, sum(pricexnumi) from invl
report must show
qty group total
4 1 2 24
2 xyz 20
2 yyy 4

3 1 3 3
3 xxx 3

6 2 2 42
2 ddd 2
4 ccc 40

CARLOSANESES

--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Carlos,

Please do not post with all capital letters. It implies that you are
yelling.

To show a calculated total before the details have printed, you need to set
the DBCalc.LookAhead property to True. This will automatically set the
report to TwoPass and make the calculation before the report is displayed.
If you need to keep a running total in the header, take a look at the
following rbWiki article.

http://www.digital-metaphors.com/rbWiki/Delphi_Code/Calculations/How_To...Keep_a_Running_Total_in_the_Header

--
Regards,

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