I have a report with one input parameter of type Multi Select Query. The datasource that I'm using is Postgres Datasource.
The control input show fine, and, I select the values without problem but the value selected is not fill in the sql statement , by example:
..... WHERE m.id IN ($1).....
The sql definition in my report is:
... WHERE $X{IN, m.id,motivos} ....
So, the error is a cast error (integer = varcharing ). For my, jasperserver not fill the value in the statement with the config value (column value) in the input control definition.
Any idea?
Thanks
0 Answers:
No answers yet
Any idea?