Select Expert using equals 1

[Jimmy2128]

I have a orders table that contains a column called Orders_Type_Code. When I go to Select expert I need to pull (2) orders_type_code that equals "ADVINV" and "CMADVINV" so I do the following:

{Orders.ORDER_TYPE_CODE} = "ADVINV"

now when I try to add the second code is giving me an error that is not a formula

{Orders.ORDER_TYPE_CODE} = "ADVINV"
{Orders.ORDER_TYPE_CODE} = "CMADVINV"

I tried this too

{Orders.ORDER_TYPE_CODE} = "ADVINV" Or "CMADVINV"

Still doesnt work.

Please any advise...

Regards,

Jym

 

[lbass]

The correct syntax is:

{Orders.ORDER_TYPE_CODE} in ["CMADVINV","ADVINV"]

-LB

 

[dgillz]

The following will work as well:

{Orders.ORDER_TYPE_CODE} = "ADVINV" or
{Orders.ORDER_TYPE_CODE} = "CMADVINV"


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz