OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Runtime Paeramter (Report 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Runtime Paeramter [message #669179]

Sat, 07 April 2018 04:32

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

i have a table with field name "Studentid" which have three different values:
1. ALI MURTUZA CAMPUS
2. USMAN-E-GHANNI
3. UMER-E-FAROOQ CAMPUS
i want to use these values in rumtime parameter form as
(ALI MURTUZA CAMPUS,USMAN-E-GHANNI)
(UMER-E-FAROOQ CAMPUS)
the query is

and fdate between :DAT and :DAT1
And studentid IN (:ZZ)   -- ZZ is the parameter values.

Report message to a moderator

Re: Runtime Paeramter [message #669188 is a reply to message #669179]

Sat, 07 April 2018 15:31

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Unless I'm wrong, it won't work that way - search for varying elements in IN list.

Or, store those values in a table and use them in a subquery.

Report message to a moderator

Re: Runtime Paeramter [message #669217 is a reply to message #669188]

Mon, 09 April 2018 03:42

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

You can make it work with a lexical parameter, but not a normal one.

Report message to a moderator

Previous Topic:	Unable to view Report
Next Topic:	Protect Report from URL sharing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 01:57:38 CDT 2026