Passing multiple values into i-report parameters

[mpenumal]

 

Hi,

I am using i-report 3.7.0 version.Here i have created a parameter and using it in the query part.How can i pass multiple values into the query through that parameter??I am able to  pass one value into that parameter.plz help me out.Thanks in advance

 

Code:

SELECT     product.`product_name` AS product_product_name,    sales_fact_1997.`store_sales` AS sales_fact_1997_store_sales,     store.`store_name` AS store_store_nameFROM     `sales_fact_1997` sales_fact_1997 INNER JOIN `product` product ON sales_fact_1997.`product_id` = product.`product_id`     INNER JOIN `store` store ON sales_fact_1997.`store_id` = store.`store_id`where  product.`product_name` in ($P{parameter2})Group By product.`product_name`,sales_fact_1997.`store_sales`,store.`store_name`order by store.`store_name`,product.`product_name`

[randyrhandz]

Can you just create two parameter instead? or if not you can still pass two values in one parameter. iReport has the capability to tokenize the value in a parameter

[despec]

From what I'm slowly understanding, you have to use a special parameter construct using the $X variable, so your IN statement would look like so:

 

where $X{IN,<Fieldname>,<Parameter Name>}

Hope this helps.

 

David