Hi there,

Is it possible to select groups where a group's records contains a certain value?

What I've got is a group of Projects grouped by Project Name. Inside the Project Group is a list (in the details) of who is involved in the project.

I want the user to be able to enter a person code and the report return all the projects containing that person and the other people involved in the project.

I can use the Select Expert to select where a person matches the entered Person Code but it wont include the other people involved in the project.

Wow so simple! Thanks.

yes, there is a formatting issue that inserted an errant 0"> is should just be sum(flag,group_field) > 0