This topic explains about the list of parameter custom properties that are supported to customize the reports preview in Report Viewer.
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.
Preview the report and the unique values showed in the parameter drop down.
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.
Preview the report and the pop up height showed in the parameter drop down.
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.
Preview the report and the pop up width showed in the parameter drop down.
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.
Preview the report and the minimum date showed in the datetime parameter drop down.
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.
Preview the report and the maximum date showed in the datetime parameter drop down.
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.
Preview the report and the see the parameter block is hidden.
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.
Preview the report and the see date time format in datetime 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.
Preview the report and the see time format 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.
Preview the report and the see time interval in datetime 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.
Preview the report and the see search filter in parameter.
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.
Before enabling date time picker type, the default value will be displayed as below..
Enable date time picker type and see the time in DateTimePicker
as in below output.
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.
Preview of report parameter drop down without sorting enabled.
Preview of report parameter drop down with sorting enabled.