Subreport Issue

Posted on 2011-10-25
Last Modified: 2012-05-12
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.
Question by:robd2007
    LVL 100

    Accepted Solution

    The only way that could happen is if you also added the Contacts table to the main report.


    Author Comment


    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?

    Author Closing Comment

    Thank you very much.

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now