iReport: Passing parameters from a main report query to a dataset query for a table or list
I understand how to pass parameters from a main report to a subreport, since there's a specific field for this in the subreport object. However, I'd like to do the same thing with a table or list object as a consumer (rather than a subreport). Is it possible?
For example, say I have a parameter of 'customerID' that I can populate with a main report query, but I can't seem to pass this parameter to the table's dataset's SQL query.
I've tried, and continue to try, various combinations of parameters, fields, and variables, but to no avail.
Does this sort of thing require a subreport implementation?
(If it matters and isn't obvious, I'm using JDBC)
Answer
To pass the parameters from main report to the table or list datasources in the iReport 3.6.7+, you need to do following steps:
1) create required parameters in the main report by right clicking on the parameters section of main report------> add parameter-------->set the properties (data type) of newly added parameter to your desired one.
2) create equivalent parameters in the table/List's data source's parameters section exactly as in step 1.
3) from report explorer, right click on the table and click on Edit Table DataSet ------> Select the parameters tab ----------->Click on add ---------->Choose the parameter (which you created in the dataset's parameter section in step 1) from upper combo (i.e. Dataset parameter name) ------> then click on lower button (i.e.) assign value expression i.e. the params which you added in step 1.
source : http://hamroblog-sristi.blogspot.fr/2011/04/passing-parameters-from-main-report-to.html