Search code examples
jasperservercascading

Cascading input control based on multiple parameter---Jasper Server

I would be thankful if anybody help me in this regard.

I have three parameters as below on jaspersoft server. and I want to build cascading input control as follows.

Parameter1 is a list with multiple select. parameter2 is also a list with multiple select.

but I want the parameter3 should be filtered as what I have selected from the above two parameter1 and parameter2.

I have tried the following third parameter3 query but getting the result one parameter1 or parameter2.

select id, name
where
$X{IN, samecolumn, parameter1}  AND $X{IN, samecolumn, parameter}

please I would be thankful for the response.

Solution

  • There is a sample for this in the Jasper Reports demo data which comes with the server. This is not a part of the documentation as far as I know.

    I searced for "cascade" in Jasper Reports Server and it is a report:

    It is called Cascading multi select topic. Its description says: Shows cascading input controls. Multi-select and single select queries.