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}
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}
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 ?