Display result of second dataset based on first dataset report parameter

Hi,
I am beginner to BIRT. I created 2 data sets, first data set has somw report parameters. I have only one column in second dataset. I need to display result of second dataset based on first dataset report parameter.

here is the queries of 2 datasets
1st dataset:
select c.end_date, c.FLYING_HRS,c.PLANNED_HRS, c.LOW,c.MED,c.HIGH,c.SUPPORT_CODE,c.CONTINENTAL_CODE,c.PERIOD_CODE from u_vw_hour_chart_by_clin c
where c.support_code = ? and c.period_code = ?

2nd dataset:

select sum(FLYING_HRS) flying_hours from U_VW_AC_STATUS_BY_PRG_PRD
where support_code = ? and period_code = ?

How can I get the result of flyinh hours based on first dataset report parameter values.

Any help in this is much appreciated.

Thanks,
Susmitha.

Find more posts tagged with

Comments

vishalkp

Hello,

Create two report parameters as:
1. support_code
2. period_code

and use them in filter of both the dataset, so that both the datasets will be filter same.

With Regards,
VishalKP.

Susmitha

Thanks very much Vishal. I am able to solve the issue. I appreciate your help.

akumar

Hi,

On the above discussion how can we bind first dataset out put parameter to second datset's input

Example

First dataset :

select a from tableA where b = ?

Second dataset

select c from tableC where a = ?

I have groping based on dataset One, and dataset two is used internal in group.

In second dataset how can I link input "a" with the output "a" of first dataset ?
I can see the option to Link only Report Parameter.

Any help in this is much appreciated.

Abhishek