Boolean problem 1

[MzKitty]

Hi. I'm using cr 10.5 and I have a boolean formula that is stumping me. I should be seeing either True or False in this field when it is in my detail line, however I have two lines where it is blank. It is not being suppressed; it's just blank. What do I do to suppress the detail line if the boolean is blank?
Here is my formula:

(previous({Tkhist1.VehicleID}) = {Tkhist1.VehicleID})
and
(previous ({Tkhist1.Qty}) = {Tkhist1.Qty})
and
(previous ({Tkhist1.TicketNo})+ 1) = {Tkhist1.TicketNo}
and
(previous ({Tkhist1.OrderID}) = {Tkhist1.OrderID})

Thanks
Cathy

 

[CoSpringsGuy]

I wonder if it is a problem with null

Try changing your formula to default values for null instead of Exceptions for null and see if you dont get false for those two lines

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

You will also get a null result on the first record where there are no previous values, unless you account for that by adding a clause:

not onfirstrecord and //etc.

-LB

 

[MzKitty]

thanks LB. It was happening on the first and last records.

Cathy