The Hidden Functionality of Custom Report Types

The Hidden Functionality of Custom Report Types v2Custom report types in Salesforce are great. They let you build an array of relationships to see data in a variety of complex ways. But they also hold some secrets that most admins don’t know about.

It wasn’t until I took the Advanced Administrator certification class that I learned the secret functionality of custom report types. With just a few extra keystrokes, administrators can make these reports far more user-friendly.

Let’s take a look!

Set Default Fields

When selecting a standard report type, Salesforce will populate the report with a few default fields. This makes the report building process much easier.

Custom report types don’t default any data adding several extra steps for users. But, you can add some immediate value to the report by defaulting fields to the report type – giving users an immediate report template to build off of.

Here’s how to do it!

  1. Access the report type by clicking Setup | Create | Report Types | Report Type Name.
  2. Click Edit Layout in the Fields Available for Reports section.
  3. Fields with a checkbox in front of the label are already defaulted. To add a field to the default layout, double-click the field name.
  4. In the window that opens, check the box titled Checked by Default.
Add_Default_Field_Checkbox

Change the field display label and indicate if the field should be defaulted on the report.

Notice that in this new window that opened, the field label can also be changed in the Display As section. The change made here doesn’t reflect on the Salesforce record – it just updates the name in the report builder and the output report.

This is an excellent way to add clarification to a particular field if there tends to be user confusion or wholly rename everything. I think there is an April Fool’s day joke in there somewhere!

Conversely, to remove a field from being a default value on the report, uncheck the  Checked by Default box.

Hide Specific Fields from Reports

Custom report types also allow us to determine which fields can be reported on.

Have old fields that you don’t want users to be able to pull into a report? Perhaps you just wish to reduce the number of fields available to report on to help streamline the report creation process. It can be done!

While fields can be removed, it is important to note that sometimes, fields also need to be added to the report type. Specifically, when adding new fields to an object, the new field doesn’t always show up in the report because it hasn’t been added to the report type.

If this seems janky to you, it is. Vote for this idea to have new fields automatically added to report types.

Alright, let’s look at how to hide or show fields on the custom report type. Follow steps 1 and 2 above to access the report type.

First of all, notice that on the right side of the page, there is a box that shows fields for each object in the report type. In the View section, choose the object to review.

Object_Fields

Determine what fields are available to report on using this field selector.

Fields that are available on the report are shaded gray. The fields with the green/brown color are hidden from the report type. This means that users will be unable to report on the data in these fields.

When a new field is added to your object, it tends to end up here – inaccessible to the report.

To add this field to the report type, simply drag it into the appropriate section.

Add Fields via Lookup

Not only can you add or remove fields related to the objects in the report type, but additional fields from related objects can be added to the report as well.

In the report type that I have been working with, Accounts and Contacts are the two primary objects. But let’s say that I want to pull in more specific information on a related object (where a lookup field is used) such as owner email address. We can do that!

In the above screenshot, you’ll notice a hyperlink under the object picklist which says Add fields related via lookup. When clicking on this, all objects related to the selected object will display. In this example, I am looking at Account Fields. When I click the link, this is what I see:

Add fields related via lookup

Dig deep into the relational database by adding additional fields from related records.

 

By clicking into any one of the options, I’m presented with and add any number of additional fields. Clicking on Account Owner, I can select any number of fields related to the owner including email address.

These additional fields are useful for adding additional context to the data but also for slicing and dicing the data multiple ways using filters.

Change Field Section Folder Names

Salesforce’s report builder does a decent job of grouping fields in the field panel, but certain fields make sense in a different folder section. There may even be a need to create a whole new custom folder section.

Field_Sections

These field folders are created by default but can be modified to meet your specific business needs.

In the above image, we can see that there are two folders in the field panel of the report – Accounts and Contacts. These folders match the sections visible in the custom report type editor (where we were adding, removing and defaulting fields above).

Let’s say that we want to create a new section and organize the fields totally different than what Salesforce provides.

Following steps 1 and 2 above to access the custom report type, the click Create New Section. Once the section is created, drag and drop any fields from other sections to this new section.

To edit the labels of existing sections, click Edit in the red header to rename.

Change Section Header

Modify the folder section names to represent your companies nomenclature.

 

Hide Unused Report Types

In the Spring ’14 release, Salesforce gave us the ability to hide unused report types. With so many default report types provided, hiding unused report types can increase adoption of reports, reduce confusion for users and streamline the process of choosing a type of report to build.

To hide specific report types:

  1. Click ReportsNew Report…
  2. Check the box titled Select Report Types to Hide
  3. Click the check mark to change it to an X and hide the report type
analytics hide report types

Cleanup the list of available report types by hiding the types that aren’t used.

With these hidden functionality gems, reporting will become more productive and provide users with a lower barrier to entry when it comes to creating their own reports. We all want self-sufficient users and simplification is one of the key components to users helping themselves.

Consider adding the report type clean-up to your list of items to audit so that they are regularly cleaned and updated and unused report types are removed from view or deleted.

What other setting or tips and tricks did I miss when it comes to report types? Let me know – leave a comment!

 

Load More Related Articles
Load More By Brent Downey
Load More In Analytics

44
Leave a Reply

avatar
23 Comment threads
21 Thread replies
1 Followers
 
Most reacted comment
Hottest comment thread
23 Comment authors
Jagadeesh.BYAZSomdatta BanerjeeSouSuzi Simmons Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Susie Kokoska
Guest
Susie Kokoska

Great stuff Brent!!

CongaPete
Guest

Great tips here! I always forget about the ability to hide report types. I have about 15 dev instances I should go back and cleanup.

The one item that I find invaluable is the ability to: Add fields related via lookup

The ability to reach through any number of lookup relationships (Standard or Custom) and pull information and details to the report level is so useful in so many ways. Really provides great utility for filtering and display of detail data.

Matt Hagey
Guest
Matt Hagey

I would create a custom report if one of the reasons applies: * You want to filter data utilizing the object model – ex. Accounts with Activities * Want to include ‘related data’ in the report that a standard report cannot provide. Ex. Cases with custom Case owner information * You want to hide select fields from the ‘general public’. Ex. a simplified ‘opportunity’ report that only includes the Top X fields. One tip – if you’re creating a custom report with an object relationship, include that information in the report label. Ex. Accounts with Opportunities or Cases with or… Read more »

Liubov
Guest
Liubov

Facing some difficulties, maybe you’ll have an idea how to overcome it
I had to create a custom object with custom fields that will calculate the split (since split only available on opportunity page). No challenge is to have these fields work for report that will be used in a drill down by person dashboard. Any ideas how to overcome it?

Sophie
Guest
Sophie

Hi Brent, it’s great to find this page it will be very helpful to our company users who always find reporting a challenge! Thanks for all the tips.
I have one issue though while I am testing, I am trying to add the default fields to a custom report and I do not see the field listed in the grid. It is a field that we have had on the Opportunities object since day one and so I would think should appear on a custom report type that was created later? Any advice here please?

Supriya
Guest
Supriya

Hi,

The custom report type in still in development status.
Report type is not visible to end user but the reports created are visible to the users.
How? please help

Thanks.

Prabu S
Guest
Prabu S

In Dev environment We have have created so many fields (approx 100 fields for 10 objects), I have to add these fields in the Custom report Types, So I have to open each and every report Type manually (Approx 120 report types) and also need to drag & Drop each fields, So totally i have to drag & Drop for 2150 times, Its painful to do.

Is there any easy way (or automated way or Programmatic way) to do it quickly and wihtout more manual effort ?

Munira Majmundar
Guest
Munira Majmundar

Excellent!!! This is so well done. I am going step by step to master these concepts! Thank you!

Latoya Williams
Guest

Thanks for creating and posting such a great article! I didn’t realize it was possible to change field section folder names in Salesforce. I need to create some short animated demos of Salesforce functionality showing the configuration for a client’s instance. What tool or application did you use to create the great animated .gif in the “Add Fields via Lookup” section of this post?

teja
Guest
teja

Hey you save my day yar. Because in my organisation we created lots of reports i stuck in a place called reports.Because in my org leads have record types.I got a requirement like create same label names fields in lead page.I stuck this place because when i come to reports it showing the same label twice i cannot create based on this.But, you saved me like create a custom report and create sections and change the name labels in reports.I want to lean Integration in sfdc can you share any posts regarding it.I will love your tips

Abhishek
Guest

Hide function hides the report type from all users. Is there a way to hide it selectively from specific set of users ?

neema
Guest
neema

Hi Brent,
I am new to SalesForce. I can create a custom report type and add filters. I am facing a problem with adding custom filters displaying a picklist for user to select. for Example: I have a custom report type between Accounts and opportunities. I want a custom field filter for “Account Type” displaying a picklist for user to select the available Account types and then click Run Report. Is this possible? I can create custom field filter “Account Type equals “Customer” but cannot diplay a picklist for the user to select

Christi
Guest
Christi

This made my day. Thanks!

Jacobqg
Guest

This is a very insightful post! Thank you, Brent! I had one more question that I am hoping you could answer for me. When I filter a report to show only contacts who have a phone number (for my call team), the report defaults to adding the the “Account” phone number whenever the “Phone” field is blank. So my call team clicks on records from the report where it is assumed that we have their phone number, only to find that all of the phone number fields are blank. I expect there is a simple solution, but the office database… Read more »

Lakshmana Rao Chintala
Guest
Lakshmana Rao Chintala

Hi All ,

I have followed the above steps and hide the report type.same like that some other user also will do like that ..How can we track this who hide the report type ..?

Lakshmana Rao Chintala
Guest
Lakshmana Rao Chintala

Thanks BRENT ,

But I have more than 100 admins in my system .

But we have to track it .many report types are hidden .is there any way …?

Minhaj Arifin
Guest
Minhaj Arifin

Thank you so much for your blog! Using your instructions I was able to get the Organization Business Hours fields to appear in a record type. What I am trying to do is tell the report not to give Data for Saturday and Sunday. But I am stuck here! Any thoughts will be appreciated!

Minhaj Arifin
Guest
Minhaj Arifin

**Sorry for the earlier comment that has a mistake. I meant Custom Report Type and not Record Type.

Thank you so much for your blog! Using your instructions I was able to get the Organization Business Hours fields to appear in a custom report type. What I am trying to do is tell the report not to give Data for Saturday and Sunday.

But I am stuck here! Any thoughts will be appreciated!

Julie C.
Guest
Julie C.

Brent, thanks so much for the tips!
I wish I would have known some of these a couple of years ago.
I’m actually struggling with a custom report type problem right now and was wondering if you might be able to help.
I would like to create a report type that is Opportunities with Partners, with and without bookings (custom object). The problem is that the custom object isn’t available after I select the Partner object…a bunch of other objects are :/
Is there any trick that can be used to pull in the custom object?

Suzi Simmons
Guest
Suzi Simmons

I want to create a custom object to manage our licenses (not community licenses.) I am trying to retrieve the number of available licenses from the company information page. I CAN create a report type of users that includes a field containing the total number of licenses available, by way of “User Fields (via lookup) Lookup Path: Users>>Profile>User License>Total Licenses But I can’t seem to do that with a formula field on a custom object. Is this possible? I want to manage our licenses, keep track of how many I have and how many are available. Is the only way… Read more »

Sou
Guest
Sou

Hi Brent, I am facing an issue in the “ADD FIELDS VIA LOOKUP” section. I have a custom object “Cycle” and I want to extract the record owner’s fields. The record owner’s data is stored is stored in the standard User object. When I use the “ADD FIELDS VIA LOOKUP” this way : Cycle >> Created By ; I get all the fields (standard+custom) of the User object. But when I go this way : Cycle >> Owner ; I get only a few fields like Name, Profile, Role etc(no custom fields). Now in my case the Created By user… Read more »

Somdatta Banerjee
Guest
Somdatta Banerjee

Hi Brent,

In Salesforce, there is a requirement for me identify the Custom Report types that are not in use. I do not have local admin rights added to my Profile. So, I can access Data loader and basic Salesforce instance. Can you suggest how to identify Customer Report types that are not in use currently?

YAZ
Guest
YAZ

Hi Brent,

I came across your website resource and I ‘ve followed this series religiously. So well put together for beginner and easy to follow. What advice do you have on how to proceed with learning salesforce. The resources out there are really overwhelming and I’d love to learn more about Salesforce admin.

SUBSCRIBE ALREADY!

SUBSCRIBE ALREADY!

Join the bomb diggity Admin Hero email list and never miss a post. Like, never ever!

Hizza! You're subscribed! Nothing but good times ahead!