Re: about developer/2000 Report designer

You can use a Lexcial parameter in your query that builds the Report.

For instance,

Your report query might be:

   SELECT * FROM EMP You could create a parameter in the Report Builder called order_by_clause, give it a default value and the reference it in your query:

SELECT * FROM EMP
&order_by_clause

The "&" causes Oracle to use the parameter in a Lexacl format (substitution prior to executing the query).

You can dynamically change the value of the order_by_clause using a runtime parameter form or pass it in on the command line.

Jason
"johnsonlu" <johnsonlu_at_ms30.url.com.tw> wrote in message news:8fofsj$bt0_at_netnews.hinet.net...
> Greating all
> Do you know ,how can use in Report Designer "dynamic sort"?
> for example:
> > SQL PLUS
> > select * from emp
> > order by &sort;
>
> In Report Designer ,how can approach sqlplus purpose?
>
> thanks!!
>
>
>
>
>
Received on Mon May 15 2000 - 00:00:00 CEST