grouping question

[nightelfdruidhunter]

G1-Purchased date (in quarter)
G2 - customer Id, # (sum of product--count only if they are product group 'A' or 'B')
------------------
@ Num_of_Product
-----------------
if {product} = "A" or {product} = "B" then 1 else 0

G3 - product category
detail - item list (item name)



ex)

G1 -1Q2006 (purchased date)
G2 -123456789 (Cust_ID) 1 (#of product--count only if it's A or B)
G3 - C (Product)
detail tin (Item list)
abx
cbs
G3 - A
detail obg
lkj

G2 - 958005135 2
G3 - A
detail obg
que
lkj
G3 - B
detail uuf
paw
.
.
.
------------------------
Is there any way to group by # of product before cust-ID group?

Please let me know if I didn't make it clear.
Thank you for your help in advance.

 

[Madawc]

You can use Top N to put groups into a particular order.

You can only group using some feature of an individual 'row', a detail line or set of records.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10