--- title: "Report Filtering Options During Runtime" slug: "report-filtering-options-during-runtime" description: "This document shows how to limit what information is displayed on a report via Column Based Filtering. This is done by clicking Add, under the FILTERS option, in the Report Designer, and selecting what criteria to filter. " updated: 2025-06-10T18:19:21Z published: 2025-06-10T18:19:21Z --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt > Use this file to discover all available pages before exploring further. # Report Filtering Options During Runtime ## Overview The [Report Viewer](/v9/docs/report-viewer-control) provides several options to [filter](/v9/docs/report-filter-glossary). Group and sort data via the Report Designer configurations and additional runtime methods.****Providing configuration at runtime allows data filtration without having to access the Report via the Report Designer. In addition, the Report filter layer is combined with the header panel, meaning that the filter and header panel will resize appropriately for a Report Viewer. --- ## Report Runtime Column Actions **Filter, Group**and**Sort** actions are available when hovering over a column header and selecting one of the icons. The icons represent **Filter**, **Group**, and **Sort**actions in this order. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749577837215.png) ### Filter 1. To add a filter based on a column, hover over the column and select the **Filter** icon. 2. Once the icon is selected, a dialog box will appear, where a value can be defined for filtering. Once the value is defined, select **APPLY.** 3. Values must match the filter to appear on the Report.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749577991643.png) ### Sort Reports can be sorted as ascending or descending values for a column or multiple columns. Selecting the **Sort** icon will cause the Report to sort rows in ascending or descending order. Multiple columns can be used to sort a Report, sorting rows based on an ordered priority.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749578071083.png) ### Group - Selecting the **Group**Icon will group similar values found under the column together. A collapsible Row header will display the shared value. - Multiple columns can utilize the **Group** action, creating sub-sections based on the **Sort** order.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749578537163.png) --- ## Additional Actions The following section details the **Search, Maximize**and **Multi Select** actions. ### Search Providing an input in the **Search**box filters out data containing the input text. Any row that contains or has a matching value will be displayed.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749578590590.png) ### Maximize The **Maximize** action allows users to expand Reports without navigating out of the Page. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749578477402.png) Selecting the icon will cause the report to appear as a popup and expand to cover the entire screen.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749578435630.png) ### Multi-Select The **Multi-Select** ability selects and applies [**Group Actions**](/v9/docs/creating-user-actions) to multiple rows****within the Report. This setting is enabled on the Report by either toggling the **Multi-Select**setting to the **ON** position or holding the **Ctrl**or the**Shift******key and clicking on one of the rows within the Report. To disable **Multi-Select**, set it to **OFF** or press **Esc**. Additional **Multi-Select**shortcut keys: **Ctrl+A** will select all entities in the Report; hit **Ctrl+A** again to deselect all entities. Pressing **Shift**and then selecting rows apart from each other will select everything between the selections. The **Multi-Select** option also indicates the number of rows selected from the Report.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749578925190.png) --- ## Runtime Behavior Via a Filter's******Runtime Behavior** settings in the **Properties**tab, Reports can be configured with additional [**Runtime Editable Filters**](https://documentation.decisions.com/v9/docs/using-inline-filters). ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749579531511.png) --- For further information on Reports, visit the [Decisions Forum](https://community.decisions.com/categories/Reports).