locked
Table Linking RRS feed

  • Question

  • I am trying to create a report in Crystal Reports and having difficulty in linking 3 tables together.  Specifically I want to have a report that shows all contacts with associated campaign responses.  the tables I am using are CONTACT, ACTIVITY PARTY, and CAMPAIGN RESPONSES.

    What are the fields I should be using to link these together, I have tried every combination that makes sense to me with no success.

    Thanks in advance.

    Jean Luc

    Thursday, August 22, 2013 4:35 PM

Answers

  • Hi Jean Luc,

    The example below should explain the link between CampaignResponse, ActivityParty and Contact:

    SELECT cr.Subject, cr.Description, c.FullName
    FROM FilteredCampaignResponse cr
    INNER JOIN FilteredActivityParty ap ON cr.ActivityId = ap.ActivityId
    INNER JOIN FilteredContact c ON ap.PartyId = c.ContactId


    Michael Palmer
    xRMPalmer     @MJFPalmer     Rockstar365

    Thursday, August 22, 2013 7:56 PM

All replies

  • Hi Jean Luc,

    The example below should explain the link between CampaignResponse, ActivityParty and Contact:

    SELECT cr.Subject, cr.Description, c.FullName
    FROM FilteredCampaignResponse cr
    INNER JOIN FilteredActivityParty ap ON cr.ActivityId = ap.ActivityId
    INNER JOIN FilteredContact c ON ap.PartyId = c.ContactId


    Michael Palmer
    xRMPalmer     @MJFPalmer     Rockstar365

    Thursday, August 22, 2013 7:56 PM
  • thanks, that was exactly what I needed, learning all the nuances of the table relations is really driving me crazy...LOL
    Thursday, August 22, 2013 9:35 PM