Formula to show certain Groups

[mtepfer]

Using CR9,

Have a report that is grouped by a client number, within that have various other information including a status number. Want to show the groups that have only status numbers of 3.

Data looks like :
Client # Name Status
1 Joe 2
1 Joe 3

2 Mike 3
2 Mike 7

3 Kevin 3
3 Kevin 3

In this instance would only want client 3's data to show.

Data is grouped on client #

Hope this is enough info, let me know if anyone needs anything else. Thanks.

 

[MCuthill]

mtepher,

Where all records within the group are 3?
or where at least one record within a group is 3?



Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[MrBillSC]

Create a formula:
// formula @StatusCnt - place in detail section.
If {table.status} <> "3" the 1 else 0

In the select expert open the Group select option and enter:
Sum({@StatusCnt},{table.Client#} = 0

This should suppress printing of any groups that have a status value other than 3.

MrBill