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}

2 thoughts on “JasperSoft Studio 6.0.1 Parameters SQL syntax”

  1. defined parameter “vMnemonic” java.lang.String

    SQL code:
    WHERE $X{IN,INVDOSE.MNEMONIC,vMnemonic}
    Error
    Invalid type java.lang.String for parameter “vMnemonic” used in and IN clause;

    can you tell me what type should I use for my parameter

Leave a Reply

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