JasperSoft Studio 6.0.1 Parameters SQL syntax

To add string parameter in our report : String Parameter $P{P1}
To add list parameter : $X{IN,sql_column_name,P1}

select * from table where name = ${P}
select * from table where $X{IN,column_name,list}

Leave a Reply

Your email address will not be published. Required fields are marked *