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]

Please don't double-post. It wastes people's time.

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

 

[nightelfdruidhunter]

Sorry Madawc, I didn't mean to post twice.
I realized that I posted my question in wrong forum but I didn't find option to delete my posting in the other forum.

 

[lbass]

I think you just need to do a group sort (report->group sort) on your inserted summary on your number or products formula at the Customer ID level.
-LB

 

[nightelfdruidhunter]

Thank you lbass and Madawc.

I tried that both group sorting and TOP N to see but didn't work.
What I'm trying to do in the report is I'd like to add one more group that show numbers (1 to x) in betwwen G1 and G2.
So all the G2 are placed under the numbers based on the @ Num_of_Product formula. all the customers (G2) who has 3 from the formular calculation grouped under 3 (new group that displays number..)
Hope this may clear what I am asking in my original posting.
Thank you for all your help!!

 

[lbass]

What do you mean by "it didn't work"? Is the problem that you don't then see a "group header"? What CR version are you using?

-LB