Can you populate a parameter dropdown list with the values in a variable?
I am trying to build a parameter that takes the values found in one of my variables and uses them as the options in the parameter's dropdown list. However, the 'Variable Name' data type in EG only lists the variable name, not the values in the variable itself.
Instead of variable name, select "String" for Data Type
and then, for data value type, select "A list of Values"
You should then see (on the left) a "Load Values" button that will let you choose a dataset and choose a variable in the dataset. On the right, you can choose either a single selection or a multiple selection. If I am going to make them pick something from a list, I ALWAYS check/select these choices:
A value is required at runtime
Prompt for value (and your list of variable values will be used)
You can decide about quoting -- I always put my own quotes, unless I'm allowing multiple values separated by a comma (as in a where clause with an IN).
For more help with setting a list of parameter values in EG, for a numeric variable or for a date value, you might consider contacting Tech Support.
As far as I know, if the values can change monthly, then you need to repopulate the list to get the new values in the drop down list.
I do not know how to repopulate the EG parameter list with code. You may want to check with Tech Support.