The dynamic list report parameter displays a drop down list to the user when collecting the report parameter values.


Display Name

The display name of the parameter displayed to the user when executing the report.


Parameter Name

The name of the parameter available to the SQL statement as an NVARCHAR value.


SQL Statement

The SQL statement to execute to obtain the values to display to the user which can be edited in the SQL Code Editor. 

  • The statement should return an [OPTIONTEXT] column that is the text to display in the drop down list.
  • The statement should return an [OPTIONVALUE] column that is the value used for the parameter in the SQL statement of the report, this may be the same as the [OPTIONTEXT]


Security Action

Determines whether the values should only be displayed in the drop down list for items that the user has read permissions. When set to remove values the SQL statement must return an [ItemID] column.


Display Default Value

Determines whether the report parameter should display an [Any Value] option in the drop down list for system administrators, or any user.