Passing list to input control using $X in query

[contentengineer]

We have created a report using the $X{IN,colName,paramName} notation.

 

(1) iReport does not parse this notation correctly; "Unrecognized SQL escape 'IN' "

 

AND

 

(2) Non of the input controls enable a user to enter a comma separated list of variables. We get Java exceptions if we choose "single value" before the parameters is displayed in the workflow.

 

iReport2.0.2 JasperServer2.0

[contentengineer]

Forget that approach.... this is far simpler:

 

 

SELECT a FROM b where c in ('$P!{paramName}');

 

Then setup two parameters:

 

name: paramInput type: String

default to: "X,Y,Z"

 

name: paramName type: String

default to: $P{paramInput}.replace(",","','")

 

produces a beautifully parsed query when paramInput is set as a single entry value (type: String)...

 

Forget $X !!!