I am using Crystal Reports X.
I have a report that shows a list of customers account details and their current balance as follows-
GH: CustName AcctNumber CreditLimit SumOfBalances
Detail: InvoiceNumber InvDate Balance -- Details section is hidden/drill down OK
There is a linked table that has contacts for each customer, many have multiple contacts
The Contacts table is as follows
CustName1 ContactA Phone
CustName1 ContactB Phone
CustName2 ContactA Phone
CustName2 ContactB Phone
CustName2 ContactC Phone
I added a subreport to the GH to look in the Customers Contacts table, i pass in ContactC and get it to display the corresponding phone number. This works, but causes the detail section to repeat each line per number of entries in CustName in the contacts table.
eg in the detail section for CustName1 each invoice would would be repeated twice, and 3 times for CustName2
What i need to know is how to stop the repetition of the detail lines, any help appreciated.