create a formula that will indicate (or flag) that row because it meets your suppression condition. You will want the flag to be a numeric result
//@flag (or whatever you want to name this formula field)
If {tblpart.number} IN ('MIS-Sales','Sales-Engineer') then 1 else 0
If you place this on the detail section you will see a 0 or 1, the 1 only being on a row that you want to use to suppress
Create a group on Acct No
insert a SUM of the @flag formula at the Acct No group level
SUM(@flag,table.Acctno)
Now you will see in the group footer that each Acct No group has either a sum of 0 (no suppression rows in the group) or >0 (at least one suppression row in that group).
You now have a group condition to either suppress or exclude the entire group.
To suppress the entire group you would need to add suppression criteria in the GH detail and GF sections.
To exclude the group you can
ooen the select expert
expand it (show formula)
select "group selection" button
add your group condition here
SUM(@flag,table.Acctno)>0
This will now exclude every group that has that group sum value >0
A few warnings on this (although not much different than suppressing).
1 -All groups still appear in the group tree.
2- All Summary functions run against all records (they run before the group select, hence the ability to use a group select)
3 - If you need totals/calculations that are excluding the removed groups you can use shared variables with conditions or at printtime
or use Crystal Running Totals (RTs). These execute after the group selection takes place.
Edited by DBlank - 15 Apr 2015 at 4:32am