Fixed List parameters can be used to restrict the acceptable values entered in a parameter to those defined by the developer.

To define a Fixed List Parameter, click on the Advanced button in the Parameter line. This will display the Advanced Properties dialogue for Parameters:

Changing Parameter Type to “Fixed List” will display a Fixed List field where a list of acceptable values can be defined. Press the Enter key after each acceptable value for the query and “Apply” to save the changes to the Parameter.

Checking Multi Select allows more than one parameter to be passed into the Dataset at run-time. Care should be taken to ensure the query has been defined to accept multiple values by use of an IN operator rather than an equals operator in the query e.g.:

SELECT *
FROM TableName
WHERE ColumnName IN :FIXED_LIST_PARAMETER

Revision: 6
Last modified: Mar 06, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment