Home » Developer & Programmer » Reports & Discoverer » Oracle 6i order by parameter from forms to reports
Oracle 6i order by parameter from forms to reports [message #358195] Mon, 10 November 2008 01:08 Go to next message
setsuma
Messages: 3
Registered: November 2008
Location: Philippines
Junior Member
Hi all,

is there a way to 'order by' a sql query in report through a parameter passed by forms?

let's say...

** forms **
add_parameter(pl_id,'P_ORDER',text_parameter,:GROUP.ORDER_BY);

call the report...

** report **
select...
from...
where...
order by :P_order

i tried the logic above but it didn't worked...

thanks in advance....

Report message to a moderator

Re: Oracle 6i order by parameter from forms to reports [message #358206 is a reply to message #358195] Mon, 10 November 2008 01:52 Go to previous messageGo to next message
setsuma
Messages: 3
Registered: November 2008
Location: Philippines
Junior Member
done...

thanks to

http://www.dulcian.com/FAQ/Developer%20FAQ.htm

#10

Report message to a moderator

Re: Oracle 6i order by parameter from forms to reports [message #358212 is a reply to message #358195] Mon, 10 November 2008 02:14 Go to previous message
setsuma
Messages: 3
Registered: November 2008
Location: Philippines
Junior Member
sorry...

false alarm...

reports doesn't accept the lexical parameter... dont know why...

question still good...

anyone knows how to solve my question...?

thanks!

Report message to a moderator

Previous Topic: multiple pdfs from a single 6i report
Next Topic: Question from a student
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 03:23:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.