Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing Group

Status
Not open for further replies.

PAH

IS-IT--Management
Jun 8, 2000
16
0
0
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
 
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
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top