tickets

paymentmethod

customers

 

The problem is that the program that generates the data does not assign a payment type for any sales ticket with zero balance.  The payment methods are cash, check, AP  (paymentmode = 1,2,3)

 

I would like to pull up all tickets for a specific customer where paymentmethod.mode=3 OR tickets.amount=0

 

another way is

paymentmethod.mode=3 OR isnull(paymentmethod.mode)

 

Thanks in advance,

Jim

 

(isnull(paymentmethod.mode) or paymentmethod.mode=3)

and

customers.custnum=123

depending on how you have crystal set to handle nulls (in multiple places in the software) it will stop evaluating when it hits the null which is not the same as returning a false and moving to the next part of the formula.

 

I am just letting you know because at one time I thought I had it sorted using the "=true" option but it was really about the order of the statement. The "=true" is redundant and in my experience not the fix.

HTH