title: passing SQL "IN" parameter list in jasperreport
body: <p>I am working on Jasper Reports and my query uses SQL 'IN' predicate.</p>
  
  <pre><code>SELECT customer_name AS NAME, 
         id_customer   AS ID 
    FROM customer 
   WHERE customer_role IN ($P{roles})
  </code></pre>
  
  <p>Here the role parameter can have 1 or more integer values and will be dynamically decided when generating the jasper report.</p>
  
  <p>Can anybody please help me on how to set the value of 'roles' parameter thru Java program dynamically.</p>