Boolean result as select criteria

[mschaefer]

I created a formula to compare two values, the ordered quantity and the received quantity. Is there a reason why I can’t use the select expert to choose between the True and the false value? Best alternative?

 

[IdoMillet]

If you want to return all records where the quantities are not the same, than add this to the record selection fromula:

{ordered_quant} <> {received_quant}

hth,
- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm

 

[Ngolem]

Your problem is not very well defined....What are you comparing? The ordered quantity to received quantity?

this certainly can be done in a record select EXCEPT
if there are multiple receivings. You cannot have summary functions in a select clause for records. Jim Broadbent

 

[mschaefer]

I have the answer...
Sum ({RECLINE.QTY_RCV}, {POLINE.SKU}) <>{POLINE.QTY_ORD}
I wanted to do this evaluation as a boolean, T or F and select True. Based on IdoMillet's response I entered the the formula in the select expert formula editor and got the desired results.

Thanks