SugarCRM Report Filters: Including the Right Data when Creating Custom Reports in SugarCRM

When creating a custom SugarCRM report, defining your filter(s) is an important step. This excerpt from our eBook, Getting Started with SugarCRM Version 6.x explains how to add filters to your reports.

SugarCRM Report: Define Filters

The Define Filters step is completed for every type of Report. In this step, you can choose one or more filters. These filters control which data is shown in your report.

For example, if you are creating a report about Leads and do not want to include Leads whose Status is Dead, you can do that with a filter.

Filters are selected based on the module where the desired field is located. Once you choose the module in the Related Modules field, a list of available fields for filtering will load in the bottom panel. Click a field to select it.

sugarcrm report

To continue with the Leads example, the Lead Status field would be in the Leads module. You would select the Leads module in the top panel, then find and click on Status in the bottom panel. When you do, Leads > Status will be added to the Define Filters panel in the center of your screen.

sugar report filter

You have several options when setting the filter. In the first drop-down, define the operator used by the filter (is, is not, is one of, etc.). For this example, you would select Is Not. The second drop-down is where you select which field value the operator should use; in this case, that would be Dead.

The Run-time checkbox determines whether a run-time filter will be used with this Report. If checked, you will be able to change your filtering choices (the first two drop-down lists) when viewing the Report and update it in real-time to see the data that matches your choice.

To remove a filter that you added accidentally, click the red minus symbol at the right end of the line.

sugar reports blog post pic 3  sugar reports blog post pic 4  sugar reports blog post pic 5  sugar reports blog post pic 6 

You can add multiple filters if you would like to show only data that meets more than one condition. By default, two or more filters are combined with the AND operator, but you can change it to an OR combination using the Select Operator drop-down at the top left corner of the Define Filters panel.

sugar reports blog post pic 7

You do not have to apply any filters; if you want your report to use all of the data records in the selected module, simply continue to the next step without adding any filters.

To help you get the idea, here is one more filtering example. Let’s say you wanted to generate a list of your current Leads, along with some information such as their phone number and lead status. (You could then print this Report and use it as a to-do list for Leads that you need to contact). In this example, you want to use two filters: you want to show only Leads assigned to you, and you do not want to show Dead leads. To show only Leads assigned to you, select the Assigned to User module on the module file tree; then choose the User Name field from the field list. Then select the Leads module and click the Status field. Change the Status filter to Is Not and Dead. The Assigned to User filter is set to the current user, so that whoever runs the report sees their own Leads listed. The resulting filters panel is shown below:

sugar reports blog post pic 8

Looking for more information about creating custom reports in SugarCRM? Technology Advisor’s eBook, Getting Started with SugarCRM Version 6.x, includes step-by-step directions and plenty of examples to help you create your own reports and analyze your CRM data effectively.

Megan Sheehan's picture
Megan Sheehan
Trainer & Business Analyst

Megan is a SugarCRM expert who helps clients design and build their CRM systems. She’s been part of the Technology Advisors team since 2012 and has written three books on SugarCRM in that time. In addition to training clients, Megan co-hosts a SugarCRM focused podcast with Justin called “Sugar Cubed CRM Talk”. She also teaches SugarCRM classes each month. Details about these courses can be found on the Sugar University webpage.

Related Articles

September 26, 2019

In SugarCRM, there are four main types of reports: rows and columns, summation, summation with details, and matrix. When you create a custom report, it is essential that you select the right report type to fit your needs. 

September 23, 2019

The SugarCRM Silent Upgrade Utility is a life saver. Here at Technology Advisors, we've banned the use of the Upgrade Wizard. With the Upgrade Wizard, there are numerous things that can go wrong. Among those things are the upload file size, permissions and timeout settings for the server. If the server is not setup correctly, the upgrade could fail to upload, fail to overwrite or create files during the upgrade or time out. Even when all these settings are correct, it still seems to fail once in a while.