Set the
Data type to String and change the Display Type to Combo Box.
4. You will notice the Dialog box changes. You can set the List of value to
Static, which means that you input this yourself at design time. If any new
options need to be inputted, you will need to put them in yourself; or you
can set it to Dynamic, which means it will be generated based on the results
of a Data Set. The advantage of this is that you can have a back-end database
someplace in which you can simply insert values and it will auto-populate
this list. So it can be populated from an existing table in your database. The
disadvantage is that you need a database, which can go offline, and you need
to maintain it. Choose Dynamic.
5. The next screen shows all the options that you can set for dynamic
generation. If you already have a Data Set, you can base the dynamic
generation on that. In this example, we will create a new, dedicated Data
Set??”strictly for populating our parameters. Go ahead and click on the Create
New... button.
6. Name the Data Set dsEmployeeJobTitles, and use the following SQL
statement:
select
distinct
CLASSICMODELS.EMPLOYEES.JOBTITLE
from
CLASSICMODELS.EMPLOYEES
7. Hit OK and exit out of the Edit Data Set Dialog. Once done, you will be
back at the Edit Parameter Dialog with the Data Set already filled in to your
new Data Set.
Pages:
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130