select
*
from
Employees
Where
EmployeeNumber = ?
Report Parameters
[ 118 ]
5. When you click on Finish, you will be brought to the Data Set Editor
screen. From here, click on the Parameters branch in the tree view on the
left-hand side.
6. You will notice that there is a Data Set Parameter that has automatically
been created for you, called param_1. It has automatically been assigned the
type of the database type already; so we don't need to change anything. You
should notice at the top of the screen that there is a red X with a comment
about a default value. This is because if you do not have a default value in
the parameter, BIRT will not have any sort of value in the parameter for
report development. So we need to put one in there. Select param_1 and click
on the Edit button.
7. Change the Name to dsprmEmployeeID, and set the Default Value to 1002.
You will notice the drop-down box that says Linked To Report Parameter.
Ignore this for now; we will come back to it. Click on OK.
Chapter 6
[ 119 ]
8. Now, if you go to Preview Results you can see you will retrieve one
Employee. Click on OK.
Report Parameters
[ 120 ]
So, we have created a Data Set with a parameter, and assigned it a default value so
that we can work with it. But we don't have a way to get user input and put that user
input into the Data Set Parameter.
Pages:
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123