Selectively suppressing rows is done in the Section Expert using a formula. However, if you're doing any summaries (counts, sums, etc.) it doesn't work as well.
To completely filter the records out of your report, do something like the following:
1. In the Select Expert, click on the formula button (if there's no selection criteria, you'll have to pick a field first.)
2. Enter something like this:
{myTable.Team} = 'Team 1' OR
({myTable.Team} = 'Team 2' and {myTable.JobTitle} = 'Blah')
Note the parentheses (in red) - you have to use them this way in order to get this to work correctly.
-Dell
IP Logged
