title: How to pass a parameter of array/collection type at Jaspersoft Studio and use it at query?
body: <p>I'm trying to pass as a parameter, an array of values to get a report from my DW, using an "IN" clause.</p>
  
  <p>The problem is that, when I set the parameter as "Array" or "Collection", it don't prompt on Jaspersoft Studio Preview screen, and I can't use it.</p>
  
  <p>The first time, I've tried to pass the parameter as a String, where $P{convenio} was a string, passed to complete "IN":</p>
  
  <pre><code>//Select and joins here...
  WHERE ("o"."status_operacao" IN ('EFETUADO', 'SUSPENSO'))
    AND ("c"."codigo" IN ( $P{convenio}))
    AND ("o"."codigo_produto" = 1)
  </code></pre>
  
  <p>It doesn't worked, returning an error "missing EOF at ')'", but there's no error of closure.</p>
  
  <p>The last option was using $X{}, so I've set de $P{convenio}, as an Array/Collection type, and turned the query like this:</p>
  
  <pre><code>//Select and joins here...
  WHERE ("o"."status_operacao" IN ('EFETUADO', 'SUSPENSO'))
    AND ($X{IN, "c"."codigo", convenio})
    AND ("o"."codigo_produto" = 1)
  </code></pre>
  
  <p>But now the param isn't prompting, and the report brings me everything.</p>