---
title: Filtering on Reports
description: "How to add filters to a report so it only includes the records you need, and how to save the filter as a preset. **Applies to:** Users with access to Reports · **Module:** Reports ## Opening a Report's Filter 1.…"
url: "https://support.symbiant.co.uk/kb/filtering-on-reports/"
updated: "2026-10-30"
category: User Basics
tags:
  - Doc
  - Excel
  - Filtering
  - Reports
  - Spreadsheets
  - Word
---

# Filtering on Reports

How to add filters to a report so it only includes the records you need, and how to save the filter as a preset.

**Applies to:** Users with access to Reports · **Module:** Reports

## Opening a Report's Filter

1. Go to **Reports** and find the report you want to filter.
2. Click **Filter** next to it (1).

![The Filter option on a report](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-01-filter-link.png)

The filter panel opens. Click **+ AND** (1) to add a condition. The **Database** option (2) is explained further down.

![The report filter panel](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-02-filter-panel.png)

The report filter works in the same way as the dashboard's Filter Editor. See [Advanced Filtering](https://support.symbiant.co.uk/kb/advanced-filtering/) for a full guide to fields, operators and values.

## Filtering on a Dropdown Field

1. Click **+ AND**, pick a dropdown field such as **Type**, then **Select**.
2. Click **<click to set value>** and pick the value from the list, for example **IT Outage**.

![Choosing a Type value](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-03-select-value.png)

1. To include more values for the same field, click **+ OR** and pick another value. Here the report includes **IT Outage** or **Supplier Failure** (1). Click **+ OR** (2) to add more.

![Type is IT Outage or Supplier Failure](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-04-or.png)

To remove a value, click it and then click the **bin** icon (1).

![Removing a value with the bin icon](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-06-remove-value.png)

## Filtering on a Date

1. Click **+ AND** and pick a date field, for example **Occurred**.
2. Click the operator (**equals**) to change how the date is compared (1). For example, choose **is greater than or equal to** to find records on or after a date.

![The date operators](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-07-date-operators.png)

1. Click **<click to set value>**. Either pick a date with the calendar, or click the small arrow (1) to choose a date relative to today (2), such as **Today**, **Yesterday** or **-1 week**.

![Relative date options](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-08-relative-dates.png)

**Tip:** Relative dates move with the calendar, so a saved filter using **-1 week** always reports on the last 7 days.

## Combining Filters

Every line you add with **+ AND** must match. This filter (1) includes IT outages and supplier failures that occurred in the last week. Click **Close** (2) when you've finished.

![A report filter with two conditions](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-05-combined.png)

The ticked box next to **Filter** (1) shows that the report has a filter applied.

![The ticked filter box](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-09-filter-ticked.png)

## Generating the Filtered Report

Click **Generate**. The report only includes the matching records:

![The filtered Incident Details report](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-12-filtered-output.png)

## Reporting on an Earlier Point in Time

The **Database** option in the filter panel (1) controls which data the report is run against:

- **Current**: today's data (the default).
- **As of** and **Since**: run the report against the history of your data from a date and time you choose, rather than today's data.

![The Database options](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-10-database.png)

See [Database History & Restoring Historical Records](https://support.symbiant.co.uk/kb/history/) for more about history.

## Saving and Loading Filter Presets

Click the **three dots (⋮)** at the end of the report's row to see:

- **Generated** (1): when you last generated the report.
- **Presets** (2): **Save...** stores the current filter under a name, **Load...** applies a saved filter, and **Default** returns the report to its default filter (removing the filter you added).

![The report's three dots menu](https://support.symbiant.co.uk/wp-content/uploads/2026/10/filtering-on-reports-11-row-menu.png)

## Related Articles

- [Generating A Report](https://support.symbiant.co.uk/kb/generating-a-report/)
- [Advanced Filtering](https://support.symbiant.co.uk/kb/advanced-filtering/)
- [Reporting Permissions](https://support.symbiant.co.uk/kb/reporting-permissions/)
