Use value returned from main dataset in sub dataset of iReport

[tvbishan]

I have created a report with Jaspersoft Studio 6.4.3.final which contains List Element. I need to use value returned from main dataset in sub dataset (List Element) query.

Main data set return something like below. (always only one record return)

CustomerName     JobIDJohn             123,146[/code]

I need to use JobID in sub dataset (List Element) query as below.

Select * from JOB where jobId in (123,146)[/code]

I need to use the 123,146 form value returned from main dataset.
How could I achieve this?