Home » Developer & Programmer » Reports & Discoverer » Runtime Paeramter (Report 6i)
Runtime Paeramter [message #669179] Sat, 07 April 2018 04:32 Go to next message
shahzad-ul-hasan
Messages: 566
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.
Re: Runtime Paeramter [message #669188 is a reply to message #669179] Sat, 07 April 2018 15:31 Go to previous messageGo to next message
Littlefoot
Messages: 21608
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.
Re: Runtime Paeramter [message #669217 is a reply to message #669188] Mon, 09 April 2018 03:42 Go to previous message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can make it work with a lexical parameter, but not a normal one.
Previous Topic: Unable to view Report
Next Topic: Protect Report from URL sharing
Goto Forum:
  


Current Time: Mon Oct 19 18:05:55 CDT 2020