issue when selecr multiple value parameter using IBM method

quiet_max1

In BIRT when I am use IBM method for parsing the parameters and select multiples values like (25, 28, 49) from item number.

For the first item it still using LIKE and pulls any item numbers contain (25)
Here what I used:

MXReportSqlFormat.createParamWhereClause("inventory.itemnum",params["item"])

and here what that doing

((inventory.itemnum like '%25%') or (inventory.itemnum = '28') or (inventory.itemnum = '49'))

So what can I do to make the parameter pull exactly the numbers (25, 28, 49)?

mwilliams

Are you talking about when you use the multi-select option of a parameter? If so, this devShare post will show you a way to handle multiple values with an IN clause.

http://www.birt-exchange.org/org/devshare/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause/