How to format values in "in" clause of a Query?

[ireportDev]

Hi,

I have a select query(Select username from users where userids in ($P{p_user_id})). This query returns rows depending upon the value passed to the paramater (p_user_id) as a prompt where I enter the user ids.

As long as I'm entering single user id (for eg. u101), its returning me the correct username. But when i enter multiple user ids (like u101,u102) in the prompt, its not retruning any data. I also tried giving the user ids inside single quotes (like 'u101','u102') in the prompt but it didn't work.

Pls let me know how should i format the input parameter(user ids) so that i get the user names.

 

thanks in advance...

[svenn]

Use $P!{your value}