Reports

Adding/Removing Report Filters

Last Updated: Jul 07, 2016 04:04PM PDT


Filters allow you to limit your report to just the rows that meet a set of criteria that you specify. For instance, you may want to look at only the work orders submitted by a particular technician within a certain date range. Filters allow you to do this. In this article, we go over how to add and remove filters.  
The filter functionality is available in the Report options area at the top of both the Report Editor and the Report Viewer **. You can filter on any field that you can report on, including all text, numeric, and date/time fields. See here for a list of what field types you can and cannot report on. The one exception to this rule is fields that are within a Table. Table fields can be included in reports, but you cannot filter on them.
 
A filter consists of three components -- a form field, a value (or values), and a relationship between the form field and the value(s). In the example below, the form field is Completed Date, the value is 12/01/2015, and the relationship is “is greater than”. The filter is telling the report to only show rows with a Completed Date after December 1, 2015.

Adding a filter

To add a filter to your report, open your report in either the Report Editor or the Report Viewer ** and do the following.

  1. Click the Add Filter button in the top left corner. A new filter row will appear in the Report options area.

  1. From the first dropdown, select the field on which you want to filter. In this example, we select “Technician”.

  1. From the second dropdown, select the desired relationship. The choices depend on the type of field you selected:
  • Text fields: is equal to, is not equal to, contains, starts with, ends with
  • Date/Time fields: is equal to, is not equal to, is greater than, is greater than or equal to, is less than, is less than or equal to, is between, is empty, is not empty
  • Drop Downs & Check Box Groups: is equal to, is not equal to, starts with, ends with
  • Check Boxes: is equal to, is not equal to
  • Number fields: is equal to, is not equal to, is greater than, is greater than or equal to, is less than, is less than or equal to, is between

            In this example, we selected “is equal to”.

  1. Finally, complete the filter specification by filling in the value. The value field type will correspond to the field type that you selected in the first dropdown. In this example, we get a dropdown, because the Technician field in our form is a dropdown. We select “Brent”.

  1. Click the Apply Filters button to apply your changes to the report. The report will immediately reload, reflecting the new filter you added.

Removing a filter

To remove a filter from your report, open your report in either the Report Editor or the Report Viewer ** and find the Report options area, where the filters are set. Then do the following.

  1. Click the Remove button to the right of the filter that you want to remove.
  2. Click Apply Filters to apply your change to the report.

The report will reload immediately, taking your filter change into account.

 
** Note: When using the Report Viewer to apply filters, you will not be able to save your changes. If you want to save your changes and make sure the same filters are seen the next time the report is opened, use the Report Editor and don’t forget to click Save when you are done.

f96791875af3f069482b7b5788b9b70b@goformz.desk-mail.com
http://assets0.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete