JasperSoft Studio 6.0.1 Parameters SQL syntax Posted on March 15, 2017June 28, 2018 by GHY 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}
farooq February 16, 2018Reply 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
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 ?