Because
we are going to use the same query as in the last example, you might want to go
ahead and copy the existing one to the clipboard.
1. Under the Data Explorer or in the Outline, expand the Report Parameters
branch, select rprmEmployeeID, and delete it. You can do this by either
right-clicking and choosing Delete, going up to the Edit menu item and
choosing Delete, or just hitting the Delete key on the keyboard.
2. Open up the dsetEmployeeInfo Data Set from either Data Explorer
or Outline.
3. Under Parameters, select dsprmEmployeeID and click on the
Remove button.
4. Click on the New button to create a new Data Set Parameter. At this point,
we are basically at Step 6 of the previous exercise. We have a new Data Set
Parameter with no linking to any sort of values, and no default value.
5. From the New Parameter Dialog, use the same information as we did in the
previous example.
Name: dsprmEmployeeID
Data Type: Integer
Direction: Input
Report Parameters
[ 124 ]
6. Click on the fx button next to the Linked To Report Parameter text box.
This will bring up the Edit Dialog for the Report Parameter, with most of the
relevant information filled in. You will notice the name is exactly the same as
the Data Set Parameter. Fill in the prompt, and set the Default Value to 1002.
Now, when you hit OK and go back to the Data Set Edit Dialog, click on Preview
Results.
Pages:
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127