crytsal grouping problem Posted on: 07/05/2005 03:17:14




I have tables as follows

ordHead
--------
orderNo
qty

ordDet
------
orderNo
descr

and ordDet can have many rows for each orderNo. ordHead can only have one row per orderNo.

I create a report and link the two tables on orderNo.

I then print ordDet.descr in the detail section, and group on orderNo. In the group header I show the ordHead.qty

I then do a grand total on qty.

So the report looks like this

Order No : 101 Qty : 10
   Descr line 1
   Descr line 2
   Descr line 3

Order No : 102 Qty : 20
   Descr line a
   Descr line b
   Descr line c

now the grand total is 90 and not 30. I can see why it is doing it but what is the solution? any ideas?

I sorted this by using a sub report.

So I created a report with the ordHead.

Then insert a subreport on the Order and linked them

Works a treat.