OraFAQ Forum: Reports & Discoverer » Report Order by columns

Home » Developer & Programmer » Reports & Discoverer » Report Order by columns

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

Report Order by columns [message #88494]

Wed, 09 October 2002 09:18

Frank Chileshe
Messages: 7
Registered: November 2001

Junior Member

Please help me,
I have created a report using developer 2000 with
the following sql:

Select emp_no, name, sex, date_born, date_employed
from my_personnel
order by emp_no, name

I want to pass the order by columns as parameters
so that I do not confine the sorting to emp_no and name
only.

I have tried to pass these as parameters but no sorting is being done ...

What is the best way for me to supply the order by columns
dynamically at runtime?

Regards,

Frank.

Report message to a moderator

Re: Report Order by columns [message #88495 is a reply to message #88494]

Wed, 09 October 2002 11:28

Sund
Messages: 6
Registered: May 2002

Junior Member

Frank

Create a user parameter called p_order. Pass the value of the paramter entered by the user on the parameter form in the sql like..

Select emp_no, name, sex, date_born, date_employed
from my_personnel
order by :p_order;

All the best.

Regards,
-Sund

Report message to a moderator

Re: Report Order by columns [message #88499 is a reply to message #88495]

Mon, 14 October 2002 04:18

Frank Chileshe
Messages: 7
Registered: November 2001

Junior Member

Dear Sund,
Thanks for the help.
I have tried your suggession but in vain.

Select emp_no, name, sex, date_born, date_employed
from my_personnel
order by :p_order

is not working.

Regards.

Frank.

Report message to a moderator

Previous Topic:	Re: Setting Printer Tray !!!
Next Topic:	page layout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 14:29:19 CST 2024