Suppressing group header #1 based on group header #2

[crystaldev1]

Hello. I'm using CR 9 and Sql Server 2005. I have two groups (group #1 and group #2). I would like to be able to suppress group #1 if there is only 1 count of group #2. For ex:

GH1: Cars
GH2: Honda
GH2: Toyota

GH1: Boat
GH2: Yamaha

Then I would like to suppress GH1: Boat and GH2: Yamaha. I tried using formula such as "SUPPRESS" if currentfield <> next(currentfield). But this would not work since there may be more than 1 detail records for each GH2. Thanks.

 

[CoSpringsGuy]

suupression formula for group1

count({field},{groupfield2}) = 1

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

I would use:

distinctcount({table.group#2field},{table.group#1field}) = 1

-LB