• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Subreport Issue

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.
  • 2
1 Solution
The only way that could happen is if you also added the Contacts table to the main report.

robd2007Author Commented:

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?
robd2007Author Commented:
Thank you very much.

Something so simple, and i never would have worked it out.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now