From the two drop-down boxes, chose JOBTITLE for both the
value and the display text. Why are they two? The reason is for Normalized
databases. You can choose an ID for the value, and a string to be displayed
to the user. For example, if you were choosing status codes for defect
tracking: You would have things like Fixed, New, and In Process as possible
statuses for an issue, and these would have ID numbers like 1, 2, and 3. You
wouldn't expect the user to know the ID codes; so you would display the
names instead.
Report Parameters
[ 126 ]
Following is the screenshot of the Dialog with the values filled in and the
Data Set created:
8. For the Default value, use Sales Rep.
Create a new Data Set called dsEmployeeList. Use the following SQL
statement:
select
*
from
CLASSICMODELS.EMPLOYEES
Chapter 6
[ 127 ]
9. In the Edit Data Set Dialog, go to the Filters category. Create a new Filter.
10. Under Expression, select JobTitle from the drop-down list.
11. Under Value 1, select Build Express from the drop-down list.
12. In the Expression Editor, under Category, select Report Parameters. Under
Sub-Category, select ---All---, and then select the Report Parameter as
rprmEmployeeJobTitle. Double-click on it until it appears in the text box.
Once it is there, click OK.
13. Click OK, and exit out of the Data Set Editor.
Pages:
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131