Crystal Report that will include organization with all contacts

Options
I'm creating a report that will list the organization name and also list the contacts. The issue that I'm having is that only one contact will show in the report. I did a browse on contact name and all the contact are there. How do I have it show-up on the report? I don't think a relationship export will give me all the information that I want in my report. Thanks for your help in advance!
Tagged:

Comments

  • Erica Esson:
    I'm creating a report that will list the organization name and also list the contacts. The issue that I'm having is that only one contact will show in the report. I did a browse on contact name and all the contact are there. How do I have it show-up on the report? I don't think a relationship export will give me all the information that I want in my report. Thanks for your help in advance!

    Is your report listing the organization repeatedly for each contact?  So if you have one organization with three contacts is the organization showing up three times?

    Try using a subreport to list all contacts for each organization.

  • Josh Bekerman:

    Is your report listing the organization repeatedly for each contact?  So if you have one organization with three contacts is the organization showing up three times?

    Try using a subreport to list all contacts for each organization.

    No, the contact doesn't repeat, only one contact show up. I did a group sort by sort_key.
  • Erica Esson:
    No, the contact doesn't repeat, only one contact show up. I did a group sort by sort_key.
    You'll need to either do a subreport, like Josh said, or create another group on the contact sort name or type or even the IDKey. Right now since it's just grouping on the organization, it's just going to pull the first contact it finds.

Categories