Re: [DEVELOPER/2000] REPORT SORT ?
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Wed, 08 Mar 2000 02:29:14 GMT
Message-ID: <_Vix4.47110$pN1.442813_at_news1.rdc1.nj.home.com>
Date: Wed, 08 Mar 2000 02:29:14 GMT
Message-ID: <_Vix4.47110$pN1.442813_at_news1.rdc1.nj.home.com>
> How to change the sort-key dynamically ?
You have 2 mechinisms to worry about.
If your report has only one group then it is simple. You can just change
the sort order in the query by passing a lexical parameter to the query and
replace the order by clause.
If you have a break group and you want to dynamically change the sort in the
break group it is a little harder.
You create a dummy sort column in your query that you pull into your break
group and make it the first column with a break order.
Then, using lexical parameters, you replace the sort column at runtime.
-- Paul Dorsey Dulcian, Inc. (212) 595-7223 web address: http://www.dulcian.com email: pdorsey_at_dulcian.com peter <misybh_at_hmc.com.tw> wrote in message news:38C5B3A4.DB739B8A_at_hmc.com.tw...Received on Wed Mar 08 2000 - 03:29:14 CET
> HI..
> How to change the sort-key dynamically ?
> write statement in alter parameter trigger?
>
>