robd2007
asked on
Subreport Issue
Hi
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much.
Something so simple, and i never would have worked it out.
Something so simple, and i never would have worked it out.
ASKER
The Contact table is in the main report. There is only 1 field from Contacts table in the main report, so if i remove it and the table from the main repport it should solve the issue?