Jan 12, 2001 #1 PAH IS-IT--Management Jun 8, 2000 16 GB I need to suppress a whole group of records if one of the records within that group contains a certain value can anyone give me the formula many thanks Paul
I need to suppress a whole group of records if one of the records within that group contains a certain value can anyone give me the formula many thanks Paul
Jan 12, 2001 #2 kenhamady Instructor Sep 10, 2000 8,794 US 3 steps. First create a formual that says: If field = value than 1 else 0 Second you create a subtotal of this formula for each group. If the subtotal is over 0 you have at least one record in that group that qualifies. Last you put a suppress condition into the GH, GF and Details sections that says suppress when the subtotal is > 0. It will look like: Sum({Forumula.field}, {Group.field}) > 0 Ken Hamady http://www.kenhamady.com/Crystal Reports Training and a Quick Reference Guide to VB/Crystal Upvote 0 Downvote
3 steps. First create a formual that says: If field = value than 1 else 0 Second you create a subtotal of this formula for each group. If the subtotal is over 0 you have at least one record in that group that qualifies. Last you put a suppress condition into the GH, GF and Details sections that says suppress when the subtotal is > 0. It will look like: Sum({Forumula.field}, {Group.field}) > 0 Ken Hamady http://www.kenhamady.com/Crystal Reports Training and a Quick Reference Guide to VB/Crystal