Help Formula!!!!

[jhermiz2]

In my select expert I need to include a lot of conditions...
but its not working..or it works on some and not all...

Here it is:

{TBLLABOR.ACTDATESTART} in {?Start Date} and
if {?FunctionalGroup} = ""
then True
else {TBLEMPLOYEE.DEPARTMENT} = {?FunctionalGroup} and
{TBLWORKORDR.WORKORDERNUMBER} <> "IMEAL" and
(if {?EmpName} = "" then
True
else
{TBLEMPLOYEE.LNAME} = {?EmpName})

It will work for a date, Functionalgroup, or an employee...but it does not perform the part that says:

{TBLLABOR.ACTDATESTART} in {?Start Date} and
{TBLWORKORDR.WORKORDERNUMBER} <> "IMEAL"

BUT if i put it on its own..mainly JUST:

{dbo_TBLLABOR.ACTDATESTART} in {?Start Date} and
{TBLWORKORDR.WORKORDERNUMBER} <> "IMEAL"

That part works...but I need all those conditions!!!!

 

[MrTBC]

unless i'm being very dumb...
surely you want either:
{TBLLABOR.ACTDATESTART} = {?Start Date}
or:
{TBLLABOR.ACTDATESTART} >= {?Start Date}

i don't know if this will help.

 

[kenhamady]

Try putting the first IF-THEN clause in a pair of parens, like you did the second IF-THEN.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[jhermiz2]

No I dont want = or >= or <=....I want "in" that is not the issue.

I will try ken's recommendation.

Thanks,
Jon

 

[kenhamady]

If you have a RANGE parameter IN is the same as EQUAL.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com