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

Category Group Header Name appear once

Status
Not open for further replies.

accessinformation

Technical User
Dec 17, 2007
13
US
Hello...I created a report which has a field for "County" (there are two counties). Each county has three different categories (fld_Category) which appear in the group. I would like the county to appear in the first section for the group so I placed the fld_County in the group header. I do not want it to appear in the other two categories.

I tried the property "hide duplicates" but it did not work

Example of what I mean

Los Angeles County

Category 1 Data Data Data
Category 2 Data Data Data
Category 3 Data Data Data

Orange County

Category 1 Data Data Data
Category 2 Data Data Data
Category 3 Data Data Data

As of now, the couty appears between each category as such:

Orange County
Category 1 Data Data Data

Orange County
Category 2 Data Data Data

Orange County
Category 3 Data Data Data


I hope this makes sense. Any and all help would be greatly appreciated.

Thank you
 
If the group header is enabled for the County group and the County textbox is in it (as opposed to the County textbox being in the Category group header), you should get the results you desire.

Let them hate - so long as they fear... Lucius Accius
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top