IF/Else within the Formula Editor being ignored

[ZanX]

Here is the code:

1. {sa_bale_class.sale_no} = {?sale_no_in} and
2. {sa_bale_class.current_division_no} <> 35 and
3. {sa_bale_class.current_division_no} <> 38 and
4. If {?drop-no-in}>0 Then
5. {sa_bale_class.sale_drop_no}={?drop-no-in}
6. Else
7. {sa_bale_class.sale_drop_no}> 0

From the -If- and down is being ignored. All that Crystal is interpreting is the first three lines. Any advice?

 

[TanmedIT]

I know ths is real general, but try enclosing the entire IF statement in parenteses. Give it a shot. Odds are slim, but who knows

 

[Darrick]

Another problem I see is in line number 5. I'm not sure what your trying to do with this line, but if you are trying to set something equal to something else then you will need to use the Crystal syntax.

Example:

VariableField := {?drop-no-in}

You must use the := in when setting something equal to something else in Crystal.

If your using VB then I woudl have to see the rest of the code or module.

Good luck,

Darrick
darrick3@yahoo.com