I have been trying to make this formula work in Select Expert:

 

If {?DateType} = True
Then {CustomerOrder.OrderDate} in {?StartDate} to {?EndDate}
Else {CustomerOrder.DueDate} in {?StartDate} to {?EndDate}
AND
(({EstAttributes.AttributeTypeKey} = 96 and {EstAttributes.Value} = 'Y' and {report_PendingOrdersByQuantity0.goodqty}<>{CustomerOrder.QuantityOrdered})
xor
(({report_PendingOrdersByQuantity0.goodqty} > ({CustomerOrder.QuantityOrdered}*1.1)) or
({report_PendingOrdersByQuantity0.goodqty} < ({CustomerOrder.QuantityOrdered}-({CustomerOrder.QuantityOrdered}*0.1)))))

 

However, I always get a ton of repeted records and the dates don't match the selected ?StartDate and ?EndDate chosen

 

I'm troubleshooting the formula and only got part of it to work properly:

 

but it doesn't give me the evaluation I need (first formula), I want the formula to evaluate both logics after ?DateType logic and select either one or the other possibility but not both. How can I do that? Does Crystal Reports Select Expert work with logical OR/XOR statements or just logical AND statement? If not, I wonder how I could work around it.

 

Thanks in advance for your help.

 

-Rafael

 

 

 

{?DateType} parameter is a boolean that will return 'True' if user chooses {CustomerOrder.OrderDate} and 'False' if user chooses {CustomerOrder.DueDate} .

 

First part of formula works well ({?DateType} IF-THEN-ELSE validation), I parenthed it properly now, thanks.

 

Formula also works well combined with second part or first logical AND statement ({report_PendingOrdersByQuantity... )  alone.

 

Problem arrives when second part of the formula gets more complicated and needs to compare two different situations/expressions that cannot be both true. After a value of 'True' is returned from the second part of the formula, then it will be compared to first part of formula for a final 'True' value that will actually display the record.

 

Now, the only way for the second part of formula evaluation to work is to add a logical XOR statement provided that

T T = F

T F = T

F T = T

F F = F

 

The first formula I wrote is the one I want to work:

 

(If {?DateType} = True
Then {CustomerOrder.OrderDate} in {?StartDate} to {?EndDate}
Else {CustomerOrder.DueDate} in {?StartDate} to {?EndDate})
and
(({EstAttributes.AttributeTypeKey} = 96 and {EstAttributes.Value} = 'Y' and {report_PendingOrdersByQuantity0.goodqty}<>{CustomerOrder.QuantityOrdered})
xor
(({report_PendingOrdersByQuantity0.goodqty} > ({CustomerOrder.QuantityOrdered}*1.1)) or
({report_PendingOrdersByQuantity0.goodqty} < ({CustomerOrder.QuantityOrdered}-({CustomerOrder.QuantityOrdered}*0.1)))))

 

Hope this makes sense, thanks again.