send a parameter to a sub-dataset

[cek.i06go]

I need to send a particular value to a sub-dataset.

dataset10 produce the table with a lot of value, for each row value invoke another dataset11 with this value like a foreach cycle that produce another table to shw in the report.

Its possible?

I hope I explained as best as possible ...

[ajinkya_c]

Hi,

You can pass the value by using parameter of main dataset to subdataset parameter.

Open the properties of table where you have to select datasource for table on same window you can provide the main parameter value to subdataset parameter.

Hope this helps.

Thanks

Ajinkya

[cek.i06go]

Its helpful yes, but i need a solution to pass each rows result of datase10 to dataset11.

Example:

Dataset10 result this SQL table (i don't know how many and the result isn't static (it's possible in the future a val4, val5 and soon)):

val1

val2

val3

 

ok, for each value use this in the sub-dataset11 for compiling the query:

select *

from myTable

where myTable.attr = val1

 

and soon...

 

It's possible?

[ajinkya_c]

Hi,

Create parameters which holds multiple values like parameter with datatyoe java.util.collection or java.util.list and asssign the value of parameters as field.

So that you will get all the values of field to parameter and map this parameter with your other dataset parameter.

Hope this helps.

Thanks,

Ajinkya