passing SQL “IN” parameter list in jasperreport

问题:

I am working on Jasper Reports and my query uses SQL 'IN' predicate.

SELECT customer_name AS NAME, 
       id_customer   AS ID 
  FROM customer 
 WHERE customer_role IN ($P{roles})

Here the role parameter can have 1 or more integer values and will be dynamically decided when generating the jasper report.

Can anybody please help me on how to set the value of 'roles' parameter thru Java program dynamically.

回答1:

Jasper Report has a special variable $X for that:

select * from customer where $X{IN,customer_role,roles}

should work. See here and here.

回答2:

Jasper Report has a special variable $X for that:

select * from customer where $X{IN,customer_role,roles}