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!

Counting Records within a Group

Status
Not open for further replies.

ste4en

Technical User
Aug 1, 2001
69
I am trying to count the records in the detail section withing a group. Where the quantity of records is >1 I want to suppress that group & detail.

Group Name: Person
Record: Address 1
Record: Address 2

Count of the detail for this person would be 2 and so would be suppressed in the report.

How do I do this. My count -count({address})produces a count of all the addresses in the data rather than just for that Person.

Thanks

Steve


 
Instead of suppression, use group selection. Go to report->selection formula->GROUP and enter:

count({table.person},{table.person}) = 1

You could count any recurring field for the first argument, but the second argument is always the group field.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top