Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsHow to pass a result set from a dataset as a parameter to another dataset?
https://www.eclipse.org/forums/index.php/mv/msg/201862/644980/#msg_644980
I have two datasets that relates to each other.
The first dataset is the manager dataset which has this query:
select manager_id from employees where role='manager' and department_id = ?;
The second set is the employee dataset which gets the manager_id from the first dataset.
select employee_name from employees where role='staff' and manager_id = ?
Is this possible to do with BIRT? Is there any tutorial that I can read about this?
Thanks heaps.]]>Joshua Partogi2010-12-15T04:09:23-00:00Re: How to pass a result set from a dataset as a parameter to another dataset?
https://www.eclipse.org/forums/index.php/mv/msg/201862/645133/#msg_645133
from the outer.
Take a look at the attached example. Look at the binding tab in the
properties view for the inner table. Click on the Data Set Parameter
button.
On 12/14/2010 11:09 PM, Joshua Partogi wrote:
> Hi there,
>
> I have two datasets that relates to each other.
> The first dataset is the manager dataset which has this query:
> select manager_id from employees where role='manager' and department_id
> = ?;
>
> select employee_name from employees where role='staff' and manager_id = ?
> Is this possible to do with BIRT? Is there any tutorial that I can read
> about this?
>
> Thanks heaps.]]>Jason Weathersby2010-12-15T16:29:01-00:00