Skip to Content
Former Member
Nov 21, 2011 at 09:02 PM

Filtering an outer group based on values of an inner group



I guess the best way to explain this is through example.

Let's say I have a report showing sales reps. I only want the sales reps who have completed at least one order in FL. But I still want to show all of that sales reps orders regardless of state. Basically, I'm grouping by SalesRep, then by State.

Is something like this possible without subreports?

Thank you.