Click to See Complete Forum and Search --> : How group/ungroup with a condition?


daraii
June 2nd, 2009, 10:50 AM
I would like to know if it is posible to group/ungroup a group with a condition. For example, if I have the the table x with the fields account, zone, gr_flag and amount. I have Group 1 that is grouped by x.zone. I would like to be able, based on the x.gr_flag, to "activate" the group when the flag is equal to 1 and to show the detail when the flag is equal to 0.

I have tried using the "Suppress" option in the group sections but the data only seems to be detailed but the grouping still occurs.

jawadhashmi
June 3rd, 2009, 01:09 AM
yes you can create the group on the formula field and your formula field will define which field to be grouped.