Dynamic reportParameter assignment

sureshrk19

Hi All,

I'm new to birt reporting; please excuse me if I'm asking something basic.

Well, here is my requirement..
I have 2 data-sets; dataset1 is a select on couple of tables i.e.,

---

select s.id,f.id from stduent s
inner join fee f on f.student_id = s.id

---

and then, I have other dataset with following query..

---

select * from fee where id=?

---

I want the send fee id to second dataset from result od first query.

I tried creating a report parameter 'fee id' and tried setting the value on 'beforeClose' script of first dataset.. it is not working for me.

I'm going to design a nested table i.e., for one student there would be multiple fee entries..I'm not sure how to send the fee id retrieved in first query to second as query parameter.

Any pointers would be highly appreciated.

Thanks,
Suresh

mwilliams

Hi Suresh,

With your nested table selected, you should be able to go to the binding tab in the property editor and see a button called "Data Set Parameter Binding...". There you can set the dataSet parameter values based on the outer table, which is bound to the other dataSet.

Hope this helps.