Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: formula coloums in order by clause in reports

Re: formula coloums in order by clause in reports

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 5 Dec 2005 17:42:37 +0100
Message-ID: <43946dfb$0$21113$626a14ce@news.free.fr>

"Haragha" <harsha7890_at_gmail.com> a écrit dans le message de news: 1133792696.885302.162410_at_o13g2000cwo.googlegroups.com...
|I have a report and i have to change in such a way that, if user pass a
| parmeter like
| customer name or margin or percent, then depending upon that he have to
| order by.
| BUT
| the problem is margin and pct are formula coloumn, there are not in
| select statement.
|
| Please help me, urgent
|
| harsha.
|

"order by" clause may contain expressions that are not in "select" clause.

Regards
Michel Cadot Received on Mon Dec 05 2005 - 10:42:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US