Crystal Report Grouping data

[nDAa]

Is there anyway that i could summary data with Crystal report as below
Data sort by : Supp/Site/Due/Chq/FC. The result would be:


Chq# FC# Chq_Due Chq_Amt PO# PO_Amt
----------------------------------------------------------- 13917 : ABC Co,.LTD

Site A65 : Landscape

0000334 FC487070 19/07/2005 1,605 PO494128 1,605

Summary by : 19/07/2005 1,605

6880865 FC501179 24/01/2007 26,981 PO492418 8,560
PO492337 4,815
Summary by : 24/01/2007 26,981

Summary by : A65 Landscape 28,586


Site A77 : Parking

0090944 FC499014 14/09/2007 3,959 PO496087 963
PO496129 2,996
0127250 FC49C011 14/09/2007 5,350 PO499103 5,350

Summary by : 14/09/2007 9,309

0012526 FC501171 24/01/2008 3,745 PO495033 3,745

Summary by : 24/01/2008 3,745

Summary by : A77 Parking 13,054


Summary by : 13914 ABC Co.,LTD 41,640



Any help is greatly appreciated

 

[lbass]

Insert groups (in this order) on the company ID, site ID, and then on date. Then right click on the chq_amt field and insert summaries (sums) at each of the three group levels.

-LB