Please explain the Cascading parameters between two tables.
select Table A
where Parameter_A = $P{prmA}
and A.Column1 in
(Table C
where
(select from Table B where Parameter_B = $P{prmB} )
union
Table C where
(select from Table B where Parameter_B = $P{prmB} )
Recommended Comments