Home » Developer & Programmer » Reports & Discoverer » Select Mulitple values from parameter in Reports6i
Select Mulitple values from parameter in Reports6i [message #88998] Wed, 23 July 2003 20:05 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi,

Can you please help. How can I select/enter multiple values from parameter field, so I can use "IN" clause in my SQL query in orcle reports6i.

Thanks,
Ravi
Re: Select Mulitple values from parameter in Reports6i [message #89019 is a reply to message #88998] Sat, 02 August 2003 06:01 Go to previous message
Rahman
Messages: 40
Registered: July 2003
Member
How can I select/enter multiple values from parameter field, so I can use "IN" clause in my SQL query in orcle reports6i.

hi ravi

go to Report Navigator:-
go Data Model->User Parameter
click + button from tool bar to create Para-field & set its property palette accordingly like data type, width etc

create many para-fields as u desire & use these filed in ur query

like u created pf1,pf2,pf3 so use these as
......in (:pf1,:pf2,pf3)
hope it'll help u
bye
rahman
Previous Topic: How to print more than 1 copy of a report with different value in Footer based on Page No
Next Topic: Report Parameter Form
Goto Forum:
  


Current Time: Thu Mar 28 16:53:12 CDT 2024