Blog

You may have come across cross filters when learning about Salesforce reports but having no immediate need for them, forget about them. It is only sometime later when faced with a reporting challenge that you may delve back and find that they are very useful and may even solve a problem that you thought you could not do with Salesforce reports.

Lets review what reports with cross filters can do:

  • Define a filter to only show parent records that have a related child record
  • Define a filter to only show parent records that do not have a related child record.

For example, you may have a request to create a report of Accounts that have had no activity in the last 12 months. Initially you may think that this is difficult to do with Salesforce, to report on what doesn’t exist. Usually you are reporting on all records or records that meet a certain filter criteria. With cross filters, creating a report of accounts with no activity in the last 12 months is extremely easy.

  1. Create a new report based on the Accounts report type
  2. Add a cross filter for Accounts with Activities
  3. Add an activity filter using Created Date greater or equal LAST 12 MONTHS

Here is what the filters will look like:

Salesforce Accounts with no activities in the last 12 months

Salesforce Accounts with no activities in the last 12 months

Cross filters work on related custom objects as well. In the following example, a custom object ‘Projects’ has been created and is related to Accounts. A cross filter can be used to report on Accounts that have incomplete projects.

Salesforce Accounts with incomplete projects

Salesforce Accounts with incomplete projects

It could also be used to find accounts that didn’t have any projects created in the last 12 months.

Salesforce Accounts without Projects within the last 12 months

Salesforce Accounts without Projects within the last 12 months

It is also possible to combine multiple cross filters. In the example below, the report will list any accounts without Activities, Cases and Opportunities.

Salesforce Accounts with No Activities Cases Opportunities

Salesforce Accounts with No Activities Cases Opportunities

Some things to be aware of :

  • You can define up to 3 cross filters in a report
  • Each cross filter can have up to have subfilters
  • Be aware of the report type you are using for the report. For example if you would like a report of Accounts with no activities, and you use the report type ‘Accounts with Activities’ you will not get any results.

So here are some examples of how you could use cross filters:

  • Accounts with no Activities in the last 12 months
  • Accounts with no Opportunities created in the last 12 months
  • Accounts that haven’t ordered a certain product in the last 12 months (if you bring order history into Salesforce)
  • Opportunities with no Activities, Competitors, Products, Contact Roles (e.g. as a quality check on the data)
  • High Priority Open Cases with no Activities in the last week
  • Cases with no case team members or case comments

What Certification are you studying for now?

Focus on Force currently provides practice exams and study guides for thirteen certifications

Salesforce Cross Filter Report Examples

You may have come across cross filters when learning about Salesforce reports but having no immediate need for them, forget about them. It is only sometime later when faced with a reporting challenge that you may delve back and find that they are very useful and may even solve a problem that you thought you could not do with Salesforce reports. Lets review what reports with cross filters can do:… Read More

Salesforce Cross Filter Report Examples

Salesforce Email Templates

When you send an email from Salesforce, such as when you use the Send Email button or triggered from a workflow, you can select an email template. Email Templates in Salesforce come in four different types: Plain Text HTML using Letterhead HTML Custom Visualforce Plain Text Email Template This is the simplest email template to create. You can create it very quickly by entering the email text and including the… Read More

Salesforce Email Templates

Salesforce Lead Conversion

I was looking for a process flow diagram, that describes what happens when a lead is converted in Salesforce. I couldn’t find one, so I made my own. Once a lead is qualified, the next step is to convert the lead. In Salesforce, when you convert a lead, there are a number of options that are part of the process flow. The first step is to press the convert button…. Read More

Salesforce Lead Conversion

How to Display a Traffic Light Indicator in Salesforce

Visual indicators are a great addition to a Salesforce page to highlight important information or values. Instead of just displaying a value, showing an image will make a much larger impact. Depending on the situation, it may be more suitable to just display a single indicator such as a caution or stop image, or if a variable can have a range of values, display a variable image according to which… Read More

How to Display a Traffic Light Indicator in Salesforce

Salesforce Platform Overview

There are a number of features and functionality that are part of the Salesforce platform and are available to all Salesforce solutions. They offer the technology or functionality that can be used either standalone (e.g. content management) or used to build upon (e.g. force.com code). As they are common across the different Salesforce applications (e.g. Sales Cloud, Service Cloud and custom applications) they are part of the Salesforce platform. The… Read More

Salesforce Platform Overview

Salesforce Activities Tab and List View

  You may wonder where the Activities tab is in Salesforce, so you can see a list view of activities. You can see the task list and calendar on the home page but what if you would like to see all of your tasks and events in a list. Well there is a way to get to a list view, but it is easy to overlook. In the calendar section… Read More

Salesforce Activities Tab and List View

Salesforce and Email – What are the options?

When it comes to Salesforce and email, it can get confusing to understand what the options are. Read on to discover 10 ways you can work with email and Salesforce together. Sending Email from Salesforce Some people may wonder whether integration to an email client such as Outlook is even necessary. If Salesforce could send and automatically process incoming emails, then couldn’t users just live in Salesforce and use it… Read More

Salesforce and Email – What are the options?

Salesforce URL Hacking

You may find yourself with the requirement to create a record from a related list and populate a number of fields. By default, Salesforce will populate the field on the related record that links the two objects, but no other fields. For example, if you create a record for a custom object related to an opportunity, the custom record will have the opportunity populated as it relates the two records,… Read More

Salesforce URL Hacking

Salesforce Joined Reports

It can be tricky to understand how Joined reports work in Salesforce. For those who have experience with database queries or other report writing tools, the name Joined report can raise expectations that it will be possible to report on data joined from different objects in the one report. A way to think of joined reports is of separate block reports where the data can be optionally grouped to ‘join’… Read More

Salesforce Joined Reports