About Lists of Values

A list of values is a defined set of values that a report consumer can select from to pass a parameter value to your data source.

If you define a menu type parameter, the list of values provides the menu of choices. You must define the list of values before you define the menu parameter. Only 999 values are allowed in a list.

Populate the list using one of the following methods:

• SQL Query — Retrieves the values from a database using a SQL query.

• Fixed Data — Retrieves the values that a user manually enters.