This is working for reports, but not if you want to make a topic of the report: Input control: Name: inp_abc Class: java.util.Collection Default Value: new ArrayList() String list variable (parameter) Name: var_abc Class: java.lang.String Default Value: $P{var_abc}.join(",",$P{inp_abc} ) Then pass the var_abc to the proc. in the proc, you can use the following syntax to get the result: select * from table where ','+@var_abc+',' like '%,'+TableColumn+',%';