You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report join should display info from Primary & Secondary table

edited Apr 21, 2020 12:18PM in Reporting & Analytics for B2C Service 4 comments

Summary

Report join should display info from Primary & Secondary table

Content

I have contact table with primary employment detail and custom object secondary employment details. 

Relationship contact(c_id) -> CO$SecEmp(ContactID)

For example  a member contains 2 secondary employment details. 

When I make a join  report shows 2 records but, I want to show 3 records (1 for primary and 2 for secondary)

Example

ContactID    Branch           Employer
1                 PriBranch1      PriEmployer1
1                 SecBranch1    SecEmployer1
1                 SecBranch2    SecEmployer2

How to do this in report?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!