OraFAQ Forum: Reports & Discoverer » passing order by clause in run time

Home » Developer & Programmer » Reports & Discoverer » passing order by clause in run time

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

passing order by clause in run time [message #125240]

Thu, 23 June 2005 23:40

rzkhan
Messages: 370
Registered: March 2005

Senior Member

could I pass "order by" clause in my reports parameter form? please guide me...
Khan

Report message to a moderator

Re: passing order by clause in run time [message #125431 is a reply to message #125240]

Sat, 25 June 2005 02:35

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

I am also interested to achieve a similar functionally.
i.e.

I want that in run time if user click heading of any column the report will sort order by that column.

So can anybody guide us the simplest trick?

Wishes
Jawad

Report message to a moderator

Re: passing order by clause in run time [message #125803 is a reply to message #125240]

Wed, 29 June 2005 05:05

gkakde
Messages: 4
Registered: June 2005
Location: Bangalore

Junior Member

We have achieved this using parameters. our order by clause reads something like this

order by decode(:wh_cl,null,rank,decode(:cond,'O',rank_o,'R',rank_r))

Report message to a moderator

Re: passing order by clause in run time [message #125805 is a reply to message #125240]

Wed, 29 June 2005 05:12

gkakde
Messages: 4
Registered: June 2005
Location: Bangalore

Junior Member

When u want to use the title as the crtiria one possible way out is to use hyperlinks which could call the same report with the parameters carefuly chosen lexically

Report message to a moderator

Re: passing order by clause in run time [message #125960 is a reply to message #125240]

Thu, 30 June 2005 02:38

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear Gnaneshwar

Using hyper link, hmm great innovation man. But it is very bulky option.

You said “order by decode(:wh_cl,null,rank,decode(:cond,'O',rank_o,'R',rank_r))”
It is not quite clear to me. Will you or some one else please send me an example form base on scott / tiger database for the same as personal favour?

Wishes
Jawad

Report message to a moderator

Previous Topic:	Special size Report sequence printing problem on stylus printer
Next Topic:	problem in procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 15:33:47 CST 2024