Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Table Linking RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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