Crystal formula translation

system · June 19, 2002, 4:24pm

The Iff function and Case statement can be found on the help screens in RB
with examples.

Mark
-----Original Message-----
From: Dr.Byte [mailto:drbyte@...]
Sent: Wednesday, June 19, 2002 2:55 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal formula translation

On Wed, 19 Jun 2002 08:13:50 -0400, you wrote:

Hello Mark,

Now the formula works perfect,
Thanx al lot !!!.
I'am more used to work with crystal, but i also want to make some
reports in RB, because sometimes the speed is much better as with
Crystal.
Are there some doc's where the syntax of the formula's is explained?

RenÃ©

>Sorry, my error. I think RB expexts only one statement so try this nested
>iif.
>
>iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","1","V02","1","V03",
>"3",""),iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","A","V02","B","V0
3
>",
>"C",""),"")
>)
>
>Mark
>-----Original Message-----
>From: Dr.Byte [mailto:drbyte@...]
>Sent: Tuesday, June 18, 2002 5:42 PM
>To: vantage@yahoogroups.com
>Subject: Re: [Vantage] Re: Crystal formula translation
>
>
>On Tue, 18 Jun 2002 17:12:18 -0400, you wrote:
>
>This is the formula i use
>
>iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","1","V02","1","V03",
>"3",""),"")
>
>iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","A","V02","B","V03",
>"C",""),"")
>
>
>>At 10:43 PM 6/18/2002 +0200, you wrote:
>>>When i just cut and paste the whole formula in RB , and when i verify
>>>the formula i get an "Syntax Error"...????
>>
>>Could be the formula is bad. Can you past it in an email for us?
>>
>>If not, sometimes R.B. is really picky about spaces (or lack of them) in
>>formulas. Try adding them around the operators ( = > < etc) and also
>>around the commas and parens if that doesn't work.
>>
>>-Wayne Cox
>> Twenty Three -- Information Technology Consulting
>> 828-685-2338
>>
>>
>>
>>
>>
>>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
>already linked your email address to a yahoo id to enable access. )
>>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>
>--=== Groeten RenÃ© ===--
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--=== Groeten RenÃ© ===--

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 16, 2002, 5:20pm

Does anyone know how to translate the above formula from Crystal
Reports to Rebort Builder syntax..??

if {ShipDtl.Packages} > 1 then
if {SHIPDTL.PKGCODE} = "V01" then "..." else
if {SHIPDTL.PKGCODE} = "V02" then "..." else
if {SHIPDTL.PKGCODE} = "V03" then "..." else
if {ShipDtl.Packages} = 1 then
if {SHIPDTL.PKGCODE} = "V01" then "..." else
if {SHIPDTL.PKGCODE} = "V02" then "..." else
if {SHIPDTL.PKGCODE} = "V03" then "..." else "";

R.Marijnissen
HOGEFA B.V.
Holland

system · June 16, 2002, 10:56pm

Try...

iif(shipdtl.packages >= 1 and lookup(shipdtl.pkgcode,"VO1,VO2,VO3") >
0,"...","")

--- In vantage@y..., "rene6464" <drbyte@x> wrote:
> Does anyone know how to translate the above formula from Crystal
> Reports to Rebort Builder syntax..??
>
> if {ShipDtl.Packages} > 1 then
> if {SHIPDTL.PKGCODE} = "V01" then "..." else
> if {SHIPDTL.PKGCODE} = "V02" then "..." else
> if {SHIPDTL.PKGCODE} = "V03" then "..." else
> if {ShipDtl.Packages} = 1 then
> if {SHIPDTL.PKGCODE} = "V01" then "..." else
> if {SHIPDTL.PKGCODE} = "V02" then "..." else
> if {SHIPDTL.PKGCODE} = "V03" then "..." else "";
>
> R.Marijnissen
> HOGEFA B.V.
> Holland

system · June 17, 2002, 8:11am

This might also work:
iif(ShipDtl.Packages>=
1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03","....",""),"")
mark
-----Original Message-----
From: lonniedrew [mailto:lonniedrew@...]
Sent: Sunday, June 16, 2002 10:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal formula translation

Try...

iif(shipdtl.packages >= 1 and lookup(shipdtl.pkgcode,"VO1,VO2,VO3") >
0,"...","")

--- In vantage@y..., "rene6464" <drbyte@x> wrote:
> Does anyone know how to translate the above formula from Crystal
> Reports to Rebort Builder syntax..??
>
> if {ShipDtl.Packages} > 1 then
> if {SHIPDTL.PKGCODE} = "V01" then "..." else
> if {SHIPDTL.PKGCODE} = "V02" then "..." else
> if {SHIPDTL.PKGCODE} = "V03" then "..." else
> if {ShipDtl.Packages} = 1 then
> if {SHIPDTL.PKGCODE} = "V01" then "..." else
> if {SHIPDTL.PKGCODE} = "V02" then "..." else
> if {SHIPDTL.PKGCODE} = "V03" then "..." else "";
>
> R.Marijnissen
> HOGEFA B.V.
> Holland

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 18, 2002, 1:08pm

On Mon, 17 Jun 2002 08:05:06 -0400, you wrote:

Hello mark,

The formula below works perfect, but i also need the second part of
the if statement in the formula with the crystal syntax, this is
because i need to know the amount of Shipdtl.packages is exactly 1
ore more.

The total crystal syntax is one formula.

R. Marijnissen
Hogefa B.V.
Holland

>This might also work:
> iif(ShipDtl.Packages>=
>1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03","....",""),"")
>mark
>-----Original Message-----
>From: lonniedrew [mailto:lonniedrew@...]
>Sent: Sunday, June 16, 2002 10:56 PM
>To: vantage@yahoogroups.com
>Subject: [Vantage] Re: Crystal formula translation
>
>
>Try...
>
>iif(shipdtl.packages >= 1 and lookup(shipdtl.pkgcode,"VO1,VO2,VO3") >
>0,"...","")
>
>--- In vantage@y..., "rene6464" <drbyte@x> wrote:
>> Does anyone know how to translate the above formula from Crystal
>> Reports to Rebort Builder syntax..??
>>
>> if {ShipDtl.Packages} > 1 then
>> if {SHIPDTL.PKGCODE} = "V01" then "..." else
>> if {SHIPDTL.PKGCODE} = "V02" then "..." else
>> if {SHIPDTL.PKGCODE} = "V03" then "..." else
>> if {ShipDtl.Packages} = 1 then
>> if {SHIPDTL.PKGCODE} = "V01" then "..." else
>> if {SHIPDTL.PKGCODE} = "V02" then "..." else
>> if {SHIPDTL.PKGCODE} = "V03" then "..." else "";
>>
>> R.Marijnissen
>> HOGEFA B.V.
>> Holland
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--=== Groeten RenÃ© ===--

system · June 18, 2002, 4:02pm

If you want to return a set of values when ShipDtl.Packages >1 and a
different set when ShipDtl.Packages=1 try

iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03",
"....",""),"")

iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03",
"....",""),"")

The only problem you might run into in RB is that the case statement is
limited to 10 values I believe.

Mark

-----Original Message-----
From: Dr.Byte [mailto:drbyte@...]
Sent: Tuesday, June 18, 2002 1:05 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal formula translation

On Mon, 17 Jun 2002 08:05:06 -0400, you wrote:

Hello mark,

The formula below works perfect, but i also need the second part of
the if statement in the formula with the crystal syntax, this is
because i need to know the amount of Shipdtl.packages is exactly 1
ore more.

The total crystal syntax is one formula.

R. Marijnissen
Hogefa B.V.
Holland

>This might also work:
> iif(ShipDtl.Packages>=
>1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03","....",""),"")
>mark
>-----Original Message-----
>From: lonniedrew [mailto:lonniedrew@...]
>Sent: Sunday, June 16, 2002 10:56 PM
>To: vantage@yahoogroups.com
>Subject: [Vantage] Re: Crystal formula translation
>
>
>Try...
>
>iif(shipdtl.packages >= 1 and lookup(shipdtl.pkgcode,"VO1,VO2,VO3") >
>0,"...","")
>
>--- In vantage@y..., "rene6464" <drbyte@x> wrote:
>> Does anyone know how to translate the above formula from Crystal
>> Reports to Rebort Builder syntax..??
>>
>> if {ShipDtl.Packages} > 1 then
>> if {SHIPDTL.PKGCODE} = "V01" then "..." else
>> if {SHIPDTL.PKGCODE} = "V02" then "..." else
>> if {SHIPDTL.PKGCODE} = "V03" then "..." else
>> if {ShipDtl.Packages} = 1 then
>> if {SHIPDTL.PKGCODE} = "V01" then "..." else
>> if {SHIPDTL.PKGCODE} = "V02" then "..." else
>> if {SHIPDTL.PKGCODE} = "V03" then "..." else "";
>>
>> R.Marijnissen
>> HOGEFA B.V.
>> Holland
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--=== Groeten RenÃ© ===--

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 18, 2002, 4:46pm

On Tue, 18 Jun 2002 15:55:35 -0400, you wrote:

When i just cut and paste the whole formula in RB , and when i verify
the formula i get an "Syntax Error"...????

>If you want to return a set of values when ShipDtl.Packages >1 and a
>different set when ShipDtl.Packages=1 try
>
>iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03",
>"....",""),"")
>
>iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03",
>"....",""),"")
>
>The only problem you might run into in RB is that the case statement is
>limited to 10 values I believe.
>
>Mark
>
>-----Original Message-----
>From: Dr.Byte [mailto:drbyte@...]
>Sent: Tuesday, June 18, 2002 1:05 PM
>To: vantage@yahoogroups.com
>Subject: Re: [Vantage] Re: Crystal formula translation
>
>
>On Mon, 17 Jun 2002 08:05:06 -0400, you wrote:
>
>Hello mark,
>
>The formula below works perfect, but i also need the second part of
>the if statement in the formula with the crystal syntax, this is
>because i need to know the amount of Shipdtl.packages is exactly 1
>ore more.
>
>The total crystal syntax is one formula.
>
>R. Marijnissen
>Hogefa B.V.
>Holland
>
>>This might also work:
>> iif(ShipDtl.Packages>=
>>1,CASE(SHIPDTL.PKGCODE,"V01","....","V02","....","V03","....",""),"")
>>mark
>>-----Original Message-----
>>From: lonniedrew [mailto:lonniedrew@...]
>>Sent: Sunday, June 16, 2002 10:56 PM
>>To: vantage@yahoogroups.com
>>Subject: [Vantage] Re: Crystal formula translation
>>
>>
>>Try...
>>
>>iif(shipdtl.packages >= 1 and lookup(shipdtl.pkgcode,"VO1,VO2,VO3") >
>>0,"...","")
>>
>>--- In vantage@y..., "rene6464" <drbyte@x> wrote:
>>> Does anyone know how to translate the above formula from Crystal
>>> Reports to Rebort Builder syntax..??
>>>
>>> if {ShipDtl.Packages} > 1 then
>>> if {SHIPDTL.PKGCODE} = "V01" then "..." else
>>> if {SHIPDTL.PKGCODE} = "V02" then "..." else
>>> if {SHIPDTL.PKGCODE} = "V03" then "..." else
>>> if {ShipDtl.Packages} = 1 then
>>> if {SHIPDTL.PKGCODE} = "V01" then "..." else
>>> if {SHIPDTL.PKGCODE} = "V02" then "..." else
>>> if {SHIPDTL.PKGCODE} = "V03" then "..." else "";
>>>
>>> R.Marijnissen
>>> HOGEFA B.V.
>>> Holland
>>
>>
>>
>>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>>already linked your email address to a yahoo id to enable access. )
>>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>>Crystal Reports and other 'goodies', please goto:
>>http://groups.yahoo.com/group/vantage/files/.
>>(2) To search through old msg's goto:
>>http://groups.yahoo.com/group/vantage/messages
>>(3) To view links to Vendors that provide Vantage services goto:
>>http://groups.yahoo.com/group/vantage/links
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>>
>>
>>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>already linked your email address to a yahoo id to enable access. )
>>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>
>--=== Groeten RenÃ© ===--
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--=== Groeten RenÃ© ===--

system · June 18, 2002, 5:12pm

At 10:43 PM 6/18/2002 +0200, you wrote:

>When i just cut and paste the whole formula in RB , and when i verify
>the formula i get an "Syntax Error"...????

Could be the formula is bad. Can you past it in an email for us?

If not, sometimes R.B. is really picky about spaces (or lack of them) in
formulas. Try adding them around the operators ( = > < etc) and also
around the commas and parens if that doesn't work.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338

system · June 18, 2002, 5:44pm

On Tue, 18 Jun 2002 17:12:18 -0400, you wrote:

This is the formula i use

iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","1","V02","1","V03",
"3",""),"")

iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","A","V02","B","V03",
"C",""),"")

>At 10:43 PM 6/18/2002 +0200, you wrote:
>>When i just cut and paste the whole formula in RB , and when i verify
>>the formula i get an "Syntax Error"...????
>
>Could be the formula is bad. Can you past it in an email for us?
>
>If not, sometimes R.B. is really picky about spaces (or lack of them) in
>formulas. Try adding them around the operators ( = > < etc) and also
>around the commas and parens if that doesn't work.
>
>-Wayne Cox
> Twenty Three -- Information Technology Consulting
> 828-685-2338
>
>
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--=== Groeten RenÃ© ===--

system · June 19, 2002, 8:20am

Sorry, my error. I think RB expexts only one statement so try this nested
iif.

iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","1","V02","1","V03",
"3",""),iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","A","V02","B","V03
",
"C",""),"")
)

Mark
-----Original Message-----
From: Dr.Byte [mailto:drbyte@...]
Sent: Tuesday, June 18, 2002 5:42 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal formula translation

On Tue, 18 Jun 2002 17:12:18 -0400, you wrote:

This is the formula i use

iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","1","V02","1","V03",
"3",""),"")

iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","A","V02","B","V03",
"C",""),"")

>At 10:43 PM 6/18/2002 +0200, you wrote:
>>When i just cut and paste the whole formula in RB , and when i verify
>>the formula i get an "Syntax Error"...????
>
>Could be the formula is bad. Can you past it in an email for us?
>
>If not, sometimes R.B. is really picky about spaces (or lack of them) in
>formulas. Try adding them around the operators ( = > < etc) and also
>around the commas and parens if that doesn't work.
>
>-Wayne Cox
> Twenty Three -- Information Technology Consulting
> 828-685-2338
>
>
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--=== Groeten RenÃ© ===--

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 19, 2002, 2:57pm

On Wed, 19 Jun 2002 08:13:50 -0400, you wrote:

Hello Mark,

Now the formula works perfect,
Thanx al lot !!!.
I'am more used to work with crystal, but i also want to make some
reports in RB, because sometimes the speed is much better as with
Crystal.
Are there some doc's where the syntax of the formula's is explained?

RenÃ©

>Sorry, my error. I think RB expexts only one statement so try this nested
>iif.
>
>iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","1","V02","1","V03",
>"3",""),iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","A","V02","B","V03
>",
>"C",""),"")
>)
>
>Mark
>-----Original Message-----
>From: Dr.Byte [mailto:drbyte@...]
>Sent: Tuesday, June 18, 2002 5:42 PM
>To: vantage@yahoogroups.com
>Subject: Re: [Vantage] Re: Crystal formula translation
>
>
>On Tue, 18 Jun 2002 17:12:18 -0400, you wrote:
>
>This is the formula i use
>
>iif(ShipDtl.Packages>1,CASE(SHIPDTL.PKGCODE,"V01","1","V02","1","V03",
>"3",""),"")
>
>iif(ShipDtl.Packages=1,CASE(SHIPDTL.PKGCODE,"V01","A","V02","B","V03",
>"C",""),"")
>
>
>>At 10:43 PM 6/18/2002 +0200, you wrote:
>>>When i just cut and paste the whole formula in RB , and when i verify
>>>the formula i get an "Syntax Error"...????
>>
>>Could be the formula is bad. Can you past it in an email for us?
>>
>>If not, sometimes R.B. is really picky about spaces (or lack of them) in
>>formulas. Try adding them around the operators ( = > < etc) and also
>>around the commas and parens if that doesn't work.
>>
>>-Wayne Cox
>> Twenty Three -- Information Technology Consulting
>> 828-685-2338
>>
>>
>>
>>
>>
>>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>already linked your email address to a yahoo id to enable access. )
>>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>
>--=== Groeten RenÃ© ===--
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and
>Crystal Reports and other 'goodies', please goto:
>http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto:
>http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

--=== Groeten RenÃ© ===--

Topic		Replies	Views
Crystal IIF statement Yahoo Archive	9	727	December 15, 2005
Crystal Reports Errors Yahoo Archive	8	732	May 30, 2002
Crystal 2008 if then else Yahoo Archive	9	645	September 24, 2013
Crystal calculation Yahoo Archive	6	413	May 29, 2002
Crystal reports Yahoo Archive	10	380	October 30, 2003

Crystal formula translation

Related Topics