Pages

Sunday, August 28, 2016

Salesforce: Report Type Object Relationships

When you relate Object in Custom Report Type, you have option of:

with or without related records (may or may not have related records)

with at least one related records (must have at least one record)

The 1st option require at least one child record, otherwise the parent record will not show in the report generated, while the 2nd option do not require any child record. You can easily change the relation from 1st to 2nd, or 2nd to 1st anytime.

Let's look at the metadata for the different, it is just in a <outerJoin>

Without Object Relationship
Now, let's take a look on simpler report type metadata which contain no object relationship - only Account for this sample, there is no <join> tag and no second <section> tag for related objects.