Report Types

What is a Report Type?

A report type has two key functions:

1.  The report type determines which records are included in a report.  Report filters then determine which records are excluded from the report.

For example, an “Opportunities” report type will include all opportunity records:

7-18-2013 1-51-16 PM

7-18-2013 2-16-32 PM

However, an “Opportunities with Products” report type will return one line for each opportunity line item (associated product).  If an opportunity has 3 associated products, it will appear as 3 lines within this report.  If an opportunity does not have any associated records, it is omitted from this report.

7-18-2013 2-17-56 PM

7-18-2013 2-16-42 PM

This explains why the grand total between each report is different.  In this org, there are 33 opportunities, and a total of 15 opportunity line items.

2.  The report type determines which fields can be added to the report.

7-19-2013 12-25-35 PM

When is the Report Type Selected?

As the first step of report creation:

7-10-2013 2-18-25 PM

Viewing the Report Type on an Existing Report

Customize the report, then the report type is displayed in the top left:

8-13-2013 2-51-20 PM

You cannot change the report type after the report is created (you would need to create a new report).

Standard and Custom Report Types

Standard report types are automatically included with standard objects and custom objects where “Allow Reports” is checked.  Standard report types cannot be customized, and automatically include standard and custom fields for each object within the report type.

Custom report types are added by an administrator.  Within a custom report type, you can specify which objects and fields are included in the report.

Custom Report Type Object Selection

When creating a custom report type, pay very close attention to the two options when selecting relationships (Each “A” record [must / may or may not] have at least one “B” record).  The objects and relationships selected determine which records will be included when reports of this type are run.

8-13-2013 3-08-36 PM

When to Create Custom Report Types

Generally speaking, unless you need a custom report type, there is no reason to create one.  Standard report types usually meet the majority of an organization’s needs.

That said, here a few common reasons why organizations create custom report types:

1.  Standard report types do not return the required set of records.

For example, I want to run an “Opportunities with Products” report that includes all opportunities (with or without products).  The standard report type will only include opportunities if they have an associated product.  However, I could create a custom report type that used an optional object relationship to meet this need:

8-15-2013 4-54-33 PM

[sc:link id=https://www.youtube.com/watch?v=R2ipwwWTrKU text=”Reports 3 Custom Type 1″]
[Must / 4m / DC Users Group]

2. Standard report types do not include field(s) that you would like on the report.

For example, I want to run an opportunity report that includes the account owner’s manager as one of the fields.  The standard opportunity report type will not allow me to add this field:

6-1-2013 5-36-24 PM

However, when I create a custom report type, I can reference this field:

6-1-2013 5-44-33 PM

Now, this field is available on the newly created report type:

6-1-2013 5-48-26 PM

[youtubelink id=o02DGzRrl90 text=”Reports 4 Custom Report Type Fields”]
[Must / 4m / DC Users Group]

20 thoughts on “Report Types”

  1. Hey John

    The videos aren’t loading – reports 3 custom type 1, reports 4 custom report type fields. These are salesforce videos, i dont know if you could do anything about it. Do you have an alternative to go through the content in videos?

    Thanks

  2. Hi John,

    If I select ‘Analytics’ from the ‘Salesforce Certified Systems Administrator guide’ dropdown menu at the top of my home page, I only see three subsections under Analytics:

    Record Types
    Analytics: Quiz
    Analytics: Feedback

    In a post above you mentioned there are more section but I dont see them.

    ‘There is more in the analytics section: http://beta.certifiedondemand.com/analytics/

    Wondering what’s wrong?

  3. The report type determines which records are included in a report. Report filters then determine which records are excluded from the report.

    I think this would be better stated as
    The report type determines which kinds of records ( type ) are included in a report. Report filters then determine which of the records are excluded from the report.

  4. Unless I want fields from related objects (your second reason for custom reports) to me it appears that cross filters can always return the necessary records required.
    I must be missing something very basic !
    The earlier video on cross filters showed it should be possible to report on a) Accounts with Contacts b) Accounts without Contacts. If I need Accounts with or without Contacts I need not have a criteria I suppose. I assume reporting Opportunities with Products is similar to Accounts with Contacts. Unless custom reports can deal with any relationship whereas cross filters deal with only parent-child relationships. I’m confused – help.

    1. This is some overlap in functionality between cross filters and report types. Report types would allow you apply specify multiple objects (including filters), pull in related field data, and are used to establish the ‘baseline’ for the report. Using filters is perfectly fine if that meets your needs, but does not have the same functionality (for example, filters wouldn’t allow you to change which objects are included in the report).

  5. Tiny correction: “Standard report types does…” should read either “Standard report type does” or Standard report types do…”


  6. … an “Opportunities with Products” report type will return one line for each opportunity line item (associated product). If an opportunity has 3 associated products, it will appear as 3 lines within this report. If an opportunity does not have any associated records, it is omitted from this report.

    My understanding is that you can build the same report by starting with a “Products” report type, adding opportunity columns to it, and cross-filtering to exclude products without opportunities. Could you confirm?

    1. I tried running a Opportunity with Products report type and found that it still shows opportunities where there are no products related.
      Any explanation for this?

Leave a Reply