Report Date Parameter

Last update: Edit

1 Introduction

A Report date parameter allows the end-user to specify a Date and time parameter for the data set that supplies the data for a Report grid. The parameter is used to filter the results in different ways so that the same report can display different sets of data.

For example, a report may show order data for a customer over a selected period, and the report date parameter can be used to specify which period should be selected.

The report date parameter is displayed in structure mode with the data set parameter name shown between square brackets and colored blue. The From and To dates shown in blue are examples to indicate that these are date fields.

Report date parameter in structure mode

2 Report Date Parameter Properties

An example of report date parameter properties is represented in the image below:

Report date parameter in structure mode

Report date parameter properties consist of the following sections:

2.1 Common Section

For more information on properties in this section, see the Common Section section in Properties Common for Widgets.

2.2 Design Properties Section

The Design Properties allow you to change spacing and alignment of the widget and hide it on phone, tablet, or desktop, if needed.

2.3 General Section

2.3.1 Parameter

Parameter is set to a data set parameter of type Date and time, the value of which is restricted by this widget. The corresponding data set must be used by one of the report widgets on the page.

2.3.2 Fields Per Row

Fields per row specifies how many date range fields can be placed beside each other in a row. There are always two rows available for data range fields. See Additional Report Date Parameter Fields, below, for more information.

2.3.3 From Caption

From specifies the text that is displayed against the from date selector, where the end-user can choose the start of the period for which data should be shown in the report.

2.3.4 To Caption

To specifies the text that is displayed against the to date selector, where the end-user can choose the end of the period for which data should be shown in the report.

2.3.5 Show From/To

Set Show from/to to Yes if the from and to field results should be shown on the report page.

Set this to No if the from and to field results should not be shown. In this case, the filter must be set using date range fields added to the report date parameter.

2.3.6 Min. Year

Min. year is the earliest year that the end-user can choose in the Year date range field.

2.3.7 Max. year

Max. year is the latest year that the end-user can choose in the Year date range field.

3 Additional Report Date Parameter Fields

You can add extra fields to allow the end-user to easily select date ranges without needing to enter both the From and To dates. For more information, see Date Range Field.