cek.i06go Posted February 19, 2014 Share Posted February 19, 2014 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 ... Link to comment Share on other sites More sharing options...
ajinkya_c Posted February 19, 2014 Share Posted February 19, 2014 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.ThanksAjinkya Link to comment Share on other sites More sharing options...
cek.i06go Posted February 19, 2014 Author Share Posted February 19, 2014 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? Link to comment Share on other sites More sharing options...
ajinkya_c Posted February 20, 2014 Share Posted February 20, 2014 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now