Re: Reports 2.5
- From: "Mark C. Stock" <mcstockX@Xenquery .com>
- Date: Tue, 10 Jan 2006 12:45:15 -0500
"DA Morgan" <damorgan@xxxxxxxxx> wrote in message
news:1136911657.989502@xxxxxxxxxxxxxxxxxxxxxx
> michael.brohan@xxxxxx wrote:
>> Hi,
>>
>> I have a query. I have a field on a summary report which is
>> abbreviated i.e. New, Aft etc.
>>
>> I want to create another field which will give the full description
>> i.e. New => New Tyres, Aft = Breakdown after hours etc.
>>
>> how is this done? I've done it before but can't remember?
>>
>> Any help appreciated
>>
>> Michael
>
> One way is with DECODE.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan@xxxxxxxxxxxxxxxx
> (replace x with u to respond)
decode? acchhhhh!
lookup table (code table)
++ mcs
.
- References:
- Reports 2.5
- From: michael . brohan
- Re: Reports 2.5
- From: DA Morgan
- Reports 2.5
- Prev by Date: repeting frame problem
- Next by Date: pro*c
- Previous by thread: Re: Reports 2.5
- Next by thread: repeting frame problem
- Index(es):
Relevant Pages
|
Loading
