2. From the Data Explorer, delete the Report Parameter dsprmEmployeeID.
rptdesign.
3. Create a new Data Set called dsEmployeeManager, and use the
following query:
SELECT
employeenumber,
lastname || ', ' || firstname employeeName,
(SELECT
lastname || ', ' || firstname
FROM
EMPLOYEES managerEmployees
WHERE
employeenumber = currentemployee.REPORTSTO
) managerName
FROM
EMPLOYEES currentemployee
union all
SELECT
employeenumber,
lastname || ', ' || firstname employeeName,
'All' managerName
FROM
EMPLOYEES currentemployee
4. In the Data Explorer, under Report Parameters, right-click on Report
Parameters and choose New Cascading Parameter.
Report Parameters
[ 130 ]
5. For the name use rcprmEmployeeManagers and enter the Prompt text.
6. Select Single Data Set.
Chapter 6
[ 131 ]
7. Click on the Add button. Enter the Dialog info as follows:
In versions of BIRT prior to 2.2, you would need to enter these values in the
Parameters grid in the New Cascading Parameter Dialog.
8. Now, click Add again, and enter the following information for the Employee:
Report Parameters
[ 132 ]
9. You can enter the Prompt text and Default value for each of these rows, just
as you would do for regular parameters.
Chapter 6
[ 133 ]
10. Hit OK. Under the Data Explorer, select dsEmployeeInfo and double-click
to open the Data Set Editor.
Pages:
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134