Re: Reports2.5...'Order by' as parameter???

Gary,
The 'ORDER BY' needs to be a lexical parameter rather than a bind variable. Lexical parameters can replace anything in a SQL statement, where bind variables can only replace values in comparison statements.

GARY G wrote:
>
> Hello, I attempted to make the Order by clause a bind variable, but didn't
> succeed.
> Does anyone know as on how to order items in reports based on user input?
> Ultimately I'd like to run a report from Form, and pass the 'order by'
> criteria to
> the report from that Form. Any suggestions on how to accomplish that task
> would be greatly appreciated.
> Thanks in advance,
> Gary
 

-- 
+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect
| EBMUD Enterprise Object Designer
| voice: (510) 287-0272    fax: (510) 287-0373
+-----------------------------------------------------