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}
How useful was this post?
Average rating / 5. Vote count:
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
Hello,
What’s your complete query ?