Passing multiple value to a report parameter

Rinki

I need to pass multiple values to a parameter at a time.
I found the following command to use ::

"SELECT * from <table name> where <column Name> in ('" + params["class"].value.replace(/,/g,"','") + "')"

but I am not getting how to use it i.e. what does this "class" mean here?
and how to use replace(/,/g,"','") + "') .

Can anybody thro some light on it !!

It ll really be a great help !!

mwilliams

Hi Rinki,<br />
<br />
Take a look at these posts from the devShare:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/338-birt-parameters-using-in-clause/#description'>BIRT Parameters - using IN clause - Designs & Code - BIRT Exchange</a><br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/535-using-in-like-clause-in-birt/#'>Using IN/LIKE Clause in BIRT - Tutorials - BIRT Exchange</a><br />
<br />
They should help you in passing multiple values in a parameter.