Date Range Filter on Pages

Prev Next

Overview

The Date Range Filter is a feature that allows custom Date ranges to be applied in real-time by the viewer of a Report in Decisions. A user applies this filter from a Report Viewer Page Component at runtime, allowing them to change the data displayed via Date. The following document demonstrates applying and utilizing a Date Range Filter on Pages in Decisions. 

Date Range Filters are not available for Reports that use data sources that are either a Flow or a Query. In these cases a custom data source is recommended.


Example

  1. CREATE a Page that contains a Report Viewer Control.
  2. From the Properties of the Report Viewer, select PICK OR CREATE DEFAULT REPORT, then CREATE a new Report.
  3. From the Report Designer, design a Report that utilizes the Account Data Source.
  4. Under Data Fields, Add Email Address and Created On Date. Then, under Filters, Add a Date Range Filter
  5. In the Properties of the Date Range Filter, change THIS YEAR to CUSTOM under SETTINGS > Date Range. Then, click APPLY. 
  6. Under SETTINGS > Date Field, select Create on Date from the drop-down; Save and close the Report Designer and the Page Designer.
  7. From the Decisions Studio, Add the Page to a Designer Project.
  8. Navigate to the added Page via the tabs at the top of the Page. Then, via the CUSTOM DATE RANGE drop-down, set a Date Range by establishing a From and To Date, and click APPLY.
  9. Verify that the Report is displaying entries within the defined Date Range

For further information on Pages, visit the Decisions Forum.