Search results
PDF

Parameter custom properties

This topic explains about the list of parameter custom properties that are supported to customize the reports preview in Report Viewer.

Show only distinct values in parameter

A parameter created with data set query values may contain duplicate values. The Report Viewer supports UniqueValueParameters custom property that helps show only unique values in the parameter drop-down while viewing the report, without creating new a data set. Refer to the below image for property setting option.

You can also provide the parameter names with comma (,) separator to set for multiple parameters.

Shows configuration of unique value parameter property in report parameter dialog

Preview the report and the unique values showed in the parameter drop down.

Preview of unique value parameter values in Report Viewer

Change the dropdown parameter pop up height value

The PopupHeight custom property specifies the height of the parameter combobox popup list in the report. By default, the PopupHeight value is 152px. You can set the PopupHeight property value, as shown in the below.

Shows configuration of pop up height property in custom property dialog

Preview the report and the pop up height showed in the parameter drop down.

Preview of pop up height in parameter values in Report Viewer

Change the dropdown parameter pop up width value

The PopupWidth custom property specifies the width of the parameter combobox popup list in the report. By default, the popup width sets based on the width of the component. You can set the PopupWidth property value, as shown in the below.

Shows configuration of pop up width property in custom property dialog

Preview the report and the pop up width showed in the parameter drop down.

Preview of pop up width in parameter values in Report Viewer

Set the minimum date range for the date report parameter

The MinDateTime custom property specifies the minimum date in the datetime parameter item. By default, the MinDateTime value is set as null. You can set the MinDateTime property value, as shown in the below.

Shows configuration of minininum date property in custom property dialog

Preview the report and the minimum date showed in the datetime parameter drop down.

Preview of minimum date in date parameter in Report Viewer

Set the maximum date range for date report parameter

The MaxDateTime custom property specifies the maximum date in the datetime parameter item. By default, the MaxDateTime value is set as null. You can set the MaxDateTime property value, as shown in the below.

Shows configuration of maximum date property in custom property dialog

Preview the report and the maximum date showed in the datetime parameter drop down.

Preview of maximum date in date parameter in Report Viewer

Hide the report parameter block

The HideParameterBlock custom property is used to hide the parameter block on report initial rendering. The property value should be boolean. By default, the HideParameterBlock value is false. You can set the HideParameterBlock property value, as shown in the below.

Shows configuration of hide parameter block property in custom property dialog

Preview the report and the see the parameter block is hidden.

Preview of hide parameter block in Report Viewer

Set date and time format for parameter

The DateTimeFormat custom property defines the date time format to be displayed in the DateTimePicker popup. By default, the DateTimeFormat value is set as empty. You can set the DateTimeFormat property value, as shown in the below.

Shows configuration of date time format property in custom property dialog

Preview the report and the see date time format in datetime parameter.

Preview of date time format in date parameter in Report Viewer

Change time display format for parameter

The TimeDisplayFormat custom property defines the time format to be displayed in the time dropdown inside the DateTimePicker popup. You must set the DateTimePickerType custom property as DateTime before setting the TimeDisplayFormat. By default, the TimeDisplayFormat value is set as empty. You can set the TimeDisplayFormat property value, as shown in the below.

Shows configuration of time display format property in custom property dialog

Preview the report and the see time format in datetime parameter.

Preview of time format in date parameter in Report Viewer

Set time interval in datetime parameter

The TimeInterval custom property is used to set the interval between the two adjacent time values in DateTimePicker popup. You must set the DateTimePickerType custom property as DateTime before setting the TimeInterval. By default, the TimeInterval value is set as 30. You can set the TimeInterval property value, as shown in the below.

Shows configuration of time interval property in custom property dialog

Preview the report and the see time interval in datetime parameter.

Preview of time interval in date parameter in Report Viewer

Enable filtering and searching in drop-down report parameter

Setting EnableFilterSearch custom property enables search and filtering option in dropdown parameter to easily find the values. The property value should be boolean. By default, the EnableFilterSearch value is false. You can set the EnableFilterSearch property value, as shown in the below.

Shows configuration of enabling filter search property in custom property dialog

Preview the report and the see search filter in parameter.

Preview of enable search filter in parameter in Report Viewer

Change date report parameter to display date time picker

You can set DateTimePickerType custom property value as DateTime to change date parameter item to display DateTimePicker for value selection as shown the below. You can set the DateTimePickerType property value, as shown in the below.

Shows configuration of datetime picker type property in custom property dialog

Before enabling date time picker type, the default value will be displayed as below..

Preview of default value of date time picker Report Viewer

Enable date time picker type and see the time in DateTimePicker as in below output.

Preview of date time picker type after setting as datetime in Report Viewer

Show the parameter values in sorted order like Ascending or Descending

A drop-down type report parameter created with multiple parameter values does not show in any specific sorting order like ascending or descending. To sort any parameter values, you need to set the Enable Sorting option in the parameter configuration panel as shown in the below image.

Shows configuration of sorting parameter property in report parameter dialog

Preview of report parameter drop down without sorting enabled. Preview of parameter values in Report Viewer before sorting

Preview of report parameter drop down with sorting enabled. Preview of sorted parameter values in Report Viewer