Home » Developer & Programmer » Reports & Discoverer » Report Order by columns
Report Order by columns [message #88494] Wed, 09 October 2002 09:18 Go to next message
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.
Re: Report Order by columns [message #88495 is a reply to message #88494] Wed, 09 October 2002 11:28 Go to previous messageGo to next message
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
Re: Report Order by columns [message #88499 is a reply to message #88495] Mon, 14 October 2002 04:18 Go to previous message
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.
Previous Topic: Re: Setting Printer Tray !!!
Next Topic: page layout
Goto Forum:
  


Current Time: Thu Mar 28 23:46:29 CDT 2024