A statement is not expected here 2

[IChang]

Hello,

I am upgrading reports from 8.5 to 10.
The following formula keeps showing that "A statement is not expected here" ( highlighten on "STD" )

IF {SO_SalesOrderHeader.OrderType} = "S" THEN "STD"
ELSE
IF {SO_SalesOrderHeader.OrderType} = "M" THEN "MST"
ELSE
IF{SO_SalesOrderHeader.OrderType} = "B" THEN "BCK"
ELSE
IF{SO_SalesOrderHeader.OrderType} = "Q" THEN "QTE"
ELSE "REP"

It works fine in CR8.5. I have some formula have the same error after upgrade to 10. Thank you

Irene

 

[synapsevampire]

Usually it says that a statement IS expected here, I've never seen Crystal say that a statement is NOT expected here, but where is this formula palced, within a standard formula field, or in some formula code for something?

Try doing a Database->Verify database.

If that doesn't help, try right clicking the {SO_SalesOrderHeader.OrderType} field and select browse data and see what it does.

-k

 

[lbass]

In the formula editor, check to make sure that in the toolbar the syntax is set to Crystal syntax, not Basic syntax.

-LB

 

[IChang]

I guess I must going crazy by working on this issue all day. The error message is "a statement IS expected here'. I don't know why I said it is not.....
I set the syntax is to Crystal syntax, and it is working. Thank you