<> is correct - try selecting it from the comparison operators selection in the formula editor and see if that works. Alternately, try encasing the whole thing in a NOT, as in NOT(({lv_acq_cr.lotsize}*43560) = {lv_acq_cr.lotsqft}).
Otherwise - are those fields numerics? Are the returning the results you are expecting? You might want to try to add to additional fields on the report as a check, one a formular field diplaying the results of the calculation and the other displaying the lotsqft field. See if they truly show up as unequal.
Randy
>I am trying to suppress a text object if two data fields are not equal to each other (lot size in Acres and lot size in Square Feet) so my Suppress Code is:
>
>({lv_acq_cr.lotsize}*43560) <> {lv_acq_cr.lotsqft}
>
>it doesn't work!--the text object always appears
>However, when I change <> to = then the word is suppressed if the two fields equal each other and not if they are different. I want the opposite!
>
>What should I use in Crystal instead of <> to get an accurate not equal to??
>
>Thank you!
>
>Lynette
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only