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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trouble Suppressing Group Header

Status
Not open for further replies.

PLeigh

IS-IT--Management
Jul 1, 2002
3
US
This is my second post for the same problem. Please Help
I'm printing a doctor telephone directory. Grouped like this:

GH1 STATE: NEW YORK
GH2 COUNTY: KINGS
GH3a SPECIALTY: KINGS SPECIALISTS
GH3b SPECIALTY: PEDIATRICIANS
details: 123 CONFUSION LN.

My problem is I have GH3a printing everytime I have a new group in GH3B. What I need is for GH3a to print once per county (GH2).
 
From the design window, right cick the section to the left of the actual report space, and select format section. The the right of the suppress checkbox is a button labeled "X-2". Click this and enter the following formula:

Not OnFirstRecord
Previous({County})={County}

This should do the trick Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
 
If GH3a should only print once per county, why haven't you made it GH2b instead?
 
DGillz for some reason that formula suppresses GH3a all together.

Naith when I do that it screws up my formating.
 
Pleigh-

I think you are putting the conditional suppress formula that dgillz in the wrong place

Look at the section expert....you will see
Group 3 header...options for ALL Group 3 sections.
Group 3a header...options for just Group 3a
Group 3b header...options for just Group 3b

Place this formula in the Group 3a section....I think you are plkacing it in th Group 3 section

Also he specified the wrong field...I don't know what field this is : KINGS SPECIALISTS but that is the field you want to test

Not OnFirstRecord
Previous({table.fieldKINGS SPECIALISTS})={{table.fieldKINGS SPECIALISTS}}

Jim Broadbent
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top