Salesforce Features

Outer Joins Reporting

Outer Join Reports With and Without Child Records

Outer_joins_thumb_v1Developer, Professional, Enterprise, and Unlimited Editions

  • Create Reports that include records with and without related child records
  • Modify existing Custom Report Types to incorporate previously excluded records

With Comprehensive Record Reporting, administrators can define whether custom reports will return records for objects that have no related-list records. Now users gain complete related list visibility on reports. For example, users can now create prospecting status reports displaying a comprehensive list of accounts regardless of whether an account has any contacts or opportunities. Users can also run campaign effectiveness reports that display all campaigns, even if a particular campaign never reached any recipients.

  • With and Without Child Record Reporting: You can display all parent records regardless of whether or not they have child records. For records with child records, one row per child will be returned.
  • Integration with Existing Custom Report Types: Comprehensive Record Reports work just as reports do currently and Existing Custom Report Types can be modified to become comprehensive record reports. Once a relationship is changed all further relationships are set as “with and without”.

Outer_joins_detail

0 Comments