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!

Displaying specific data if they have more then one record.

Status
Not open for further replies.

mcallaghan

IS-IT--Management
Mar 22, 2005
43
0
0
US
I am trying to only display the data if they have more then one order per group. I need to display each record it has different info but they are all grouped by id. Currently I created a array within the group in the detail but its showing the data data multiple times. Does anyone have any suggestion on how to do this.

if person 1 has 1 orders so i don't want to display him.
person 2 has 2 orders so i do want to display both orders so order number 1 and order numb2

id name order #
2 jack 123
345

Note the person can have more then 2 orders
 
From what I understand, you only want the details to show when there is more than 1 record per group. Assuming I understand correctly, add a summary to count Order# records within the customer_id group, then add a the following to your Group Selection:

Count({table.order#}, {table.customer_id}) > 1

Hope this helps,
Pete.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top