Group Selection

[northw]

Hi All,
I have a issue with a group selection formula.
I have a report which should displayonly the records that has two active status on it.
I wrote a group selection clause
count(active_status)>1
It displays all the records that has active status, Okay makes sense.
But when I add a key field for that group.
count({Member_id}, {Active status})>1
I get an error "There must be a field that matches the group"
Please suggest what should I change in the formula.

Thanks.

 

[IanWaterman]

The formula you have used is a group summary

count({Member_id}, {Active status})

This will return a count of Member ID for the group Active Status, you have to group data by active status before you can use such a summary.

Ian

 

[northw]

Thanks Ian, It works...But, there is something I am missing here. Let me explain my requirement.
I have to display the customer details with two active statuses on his/her record.
I have Cust_ID (Unique field), Act_status('Active' and can have nulls), act_dt(can be null), close_date(can be null), open_dt(can be null), ref_key(non unique/sometimes same ref_key for all active statuses)
I have written a group selection clause:
Grouped on cust_id, ref_key, act_status
Count(cust_id, act_status)>1 and
Max(act_dt, ref_key)> 01/01/2009 or
Max(close_dt, ref_key)> 01/01/2009 or
Max(open_dt, ref_key)> 01/01/2009

With these group selection criteria, I am not able to display any records.
where actually there are records.

Please suggest,
Thanks in advance.