Fear not! Because next we will create a Report
Parameter and bind it to the Data Set for use in our report.
9. From the Data Explorer, go to Report Parameters, right-click on it, and
choose New Parameter from the list.
10. On the next screen, you enter the properties for the Report Parameter. Here,
we can set the Report Parameter as required for report execution. There are
several options, such as:
Hidden: which means the user will not see it in the parameter
Dialog, although we can still pass values when calling the
report with a URL.
Is Required: which makes a value in the parameter mandatory.
Do not echo input: which is useful for sensitive information.
11. Use the following values, and check the Is Required check box:
Field Value
Name rprmEmployeeID
Prompt text Enter Employee ID
Data type Integer
Display type Text Box
?°
?° ?°
Chapter 6
[ 121 ]
12. Click OK. At this point, there is no binding between the Data Set and the
Report Parameter. To create the binding, start off by Double-clicking on
dsetEmployeeInfo in the Data Explorer to open the Edit Data Set Dialog.
13. Go to the Parameters category. Double-click on dsprmEmploeeID or select it
and click on the Edit button.
14. There are two different ways we can bind the parameter to the Data Set at
this point. The easiest way is to select rprmEmployeeID from the Linked
To Report Parameter drop-down box.
Pages:
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124