Your New Best Friend…Salesforce Custom Report Types


As a Salesforce system administrator, you are no doubt tasked with creating reports. Salesforce does a good job of offering lots of report types for objects. But what if you need to create a report and just can’t seem to pull in the necessary data? My advice…try creating a custom report type.

Salesforce standard reports that pull data from more than one record will always be set up to show “Object A” with “Object B,” such as “Accounts with Contacts.” You won’t see a standard report that offers “Object A” with or without “Object B,” such as “Accounts with or without Contacts.” This can only happen through the creation of a custom report type. If you only search “Accounts with Contacts,” you may be missing out on some important data.

When creating custom report types, there are some things you should know:

  1. Custom report types allow up to four related objects to be pulled into the same report: a primary object with up to three additional related objects.
  2. When creating the custom report type, you’ll need to choose the relationship between the objects in the report (e.g. “Each ‘A’ record must have at least one related ‘B’ record or ‘A’ records may or may not have related ‘B’ records.”)
  3. When creating the custom report, you can choose which fields on each object should be included as options to pull into the report. You can choose up to 60 object references and 1,000 fields total.
  4. History fields, product schedule fields, and case age fields cannot be pulled into custom report types.
  5. Once created, the primary object cannot be changed.
  6. If you create new fields on an object after the custom report type is created, they will not appear in the list of fields to pull into the report. You must edit the custom report type to make those new fields available to pull into the report.
  7. When selecting which fields to make available in the report type, you can choose the order in which they appear in the report builder.

Although standard report types will meet most of your reporting needs, custom report types can definitely come in handy and can quickly become your new best friend.

Recent Posts

“What can I say about Virtuoso other than wow! Their Salesforce experience, expertise, and guidance have given our company a customized platform that puts us head and shoulders above our competition. It is no stretch to say Virtuoso truly transformed our business. When we started, our staff was running our business on spreadsheets, pad and […]

Read More
Customized Salesforce to our Business Needs

“With the help of Virtuoso, we have been able to customize Salesforce to our business needs. The knowledge and programming skills they have brought us have allowed us to continue work as usual. Virtuoso is setting us up with the resources we need to have continued success with Salesforce. Their team brings a sense of […]

Read More
They are Part of Your Team

“We have and continue to have the pleasure of working with the Virtuoso team for our ‘CRM Journey.’  Their team has patiently worked with our team to customize a platform that fits our business process and workflow while providing us continuity and continued consulting to align with new and different sales projects.  Wearing many hats […]

Read More
1 2 3 30
© 2024 Virtuoso Chicago, LLC.
Privacy Policy
A member of the SMG3 family