Right its a CR 8.0 formula. I apologize for the screw up in typing. I want
to use decode in the same manner in an Oracle View and Procedure. Hence the
need for DECODE or CASE. Thanks
Robert Chin <chinman_at_optonline.net> wrote in message
news:rLKF7.41540$D7.10129710_at_news02.optonline.net...
> Waaaait a minute, That is a CR formula, isn't it ?
> I don't recall CR up to version 7 has a DECODE function.
> You're talking about Oracle's DECODE, right ?
> so what does that have anything to do with
> this your formula ? I'm sure you know that you can create an
> Oracle DECODE expression in CR and reference that in other formula.
> I think version 8 supports CASE in the VB-like formula language.
>
> --
> Robert Chin
>
> "Brian McKenzie" <brian_at_stallingscrop.com> wrote in message
> news:ylCF7.67417$U7.5570247_at_bin1.nnrp.aus1.giganews.com...
> > Hello All
> >
> > I have the following expression in a crystal reports report against an
> > Oracle
> > 8i Databse.
> >
> > <----SNIP---->
> > IF {COMMISSION_01.POLICYTYPE} = "MPCI" Then
> > IF {COMMISSION_01.ISCAT} = "No" Then
> > IF {COMMISSION_01.ISCANCELLED} = "No" Then
> > "MPCI"
> > Else
> > "CANCELLED"
> > Else
> > "CAT"
> > Else
> > "CRC"
> > <----SNIP---->
> >
> > PolicyType Column contains 2 values MPCI,CRC
> > ISCAT has 2 values Yes, No
> > ISCANCELLED has 2 values Yes, NO
> >
> > New column will have an End result with 4 values MPCI, CRC, CAT,
CANCELLED
> >
> > I am not sure I am explaining this properly, tell me so and I will be
> happy
> > to expand
> >
> > Should I use CASE, DECODE or am I barking at the wrong trees. I have
drug
> > out the manuals and scoured some newsgroups, but I just cant seem to get
> > this one. Any suggestions or referances?
> >
> > Thanks
> > Brian
> >
> >
> >
>
>
>
Received on Tue Nov 06 2001 - 06:16:11 CST
