Hello,

I'm trying to add the if statement below in a reports select expert:

({Stock.PegItem} = -1 Or {StockOut.PegItem} = -1)

If I check the statement for errors everything is ok, but only the first portion of the "or" appears to be being applied. In this case records where Stock.PegItem = -1 are displayed. If I switched them around only records where StockOut.PegItem} = -1 are being shown.

I've checked the SQL statement Crystal is creating and that returns all the records I would expect. Any help would be great.

Thanks,
Andrew