Date Picker is a filtering element on the dashboard panel that is used to determine the calendar range and filter the data for the analysis in the viewer, taking into account the specified range. It can be located anywhere on the dashboard panel. Depending on the size of the dashboard panel in the viewer, it can grow or shrink by width only.
 

 

 

This chapter will cover the following:

Date Picker editor;

Table Of Properties.

 

The Date Picker element can only be the main filtering element for other filtering elements and cannot depend on the values of other filtering elements. The Date Picker can have the following selection modes:

Single. By default, the current date of the operating system and the subsequent range will be determined depending on the value of the Condition parameter.

Range. By default, the current day range will be set.

Auto Range. By default, the range will be set from an earlier date in the data source to the latest date. In other words, the original date range will correspond to the data range of the data source.
 

You may setup the Date Picker element in the editor. To call the editor, you should to the following in the report designer:

Double-click on the Date Picker element;

Select the Date Picker and choose the Design command in the context menu.
 

 

The Date Picker editor

In this editor you can add elements with data, set up the mode for selecting values, select the main filtering element.

 

 

The Key field. The data element is specified in it, according to the values of which the data will be filtered.

The Field field. Displays the expression of the selected item data field.

The Selection Mode field. It selects the mode of the Date Picker item. The following values can be selected:

Single. The current date of the operating system and the subsequent range will be determined depending on the value of the Condition parameter.

Range. By default, the current day range will be set.

Auto Range. By default, the range will be set from an earlier date from the data source to the latest. In other words, the original date range will correspond to the data range of the data source.

The Condition field. Depending on the selected item mode, the following parameters may be present:

The Condition parameter is available only if the Single mode is selected. The value of this parameter is a logical operation that determines the continuation of the date range from the current date. For example, if Greater then is selected, then the default element range will include all subsequent dates from the current date of the operating system.

The Initial Selection parameter is available only if Range is selected. You can specify the default element range. For example, you can select the previous week. Then when you open the dashboard in the viewer, the range of the Date Picker item will be set to the previous week.

 

Get acquainted with the step-by-step instruction in the Dashboards with Date Picker chapter.

 

 

List of properties

The list shows the name and description of the properties of the element which you may find in the properties panel of the report designer.