Re: Reports 6.0
From: Peter L <news_at_lenniep.freeserve.co.uk>
Date: Tue, 10 Aug 1999 23:28:40 +0100
Message-ID: <7or59q$njl$1_at_news8.svr.pol.co.uk>
Date: Tue, 10 Aug 1999 23:28:40 +0100
Message-ID: <7or59q$njl$1_at_news8.svr.pol.co.uk>
rajini_1000_at_my-deja.com wrote in message <7omqco$h6k$1_at_nnrp1.deja.com>...
>My problem is that i want to order the group item in a custom order
>using decode function.
>
>ie, the group fields should be ordered in the following order.
>EMP
>TRA
>SER etc which does not follow ASC or DESC.
>
>Any work around???
>-Rajini
You could try selecting something like
decode(your_field,'EMP',1,'TRA',2,'SER',3) order_field
Don't show the field but use it to control the order. Received on Wed Aug 11 1999 - 00:28:40 CEST