i am going to build a report using Report Builder 6.and my requirement is that i want to add parameter which takes multiple values seperated with commas...is it possible if so please tell how is it possible....query can be as

select * from emp where empno not in(:empno)

this takes only one empno but my requirment is that when the report ask for parameter i want to give more than one value against empno....

Hope you will be fine and enjoying your life very well. as you refer the document. it is only possible when i create a new table or create a new field in table and populate the lov from that specific field...but i donot want to do that i want this with out alter or creation of table..is it possible or not..and the answers available run on sql prompt but in in parameter form of report..so please provide me the solution which is also applicable in oracle reports builders.