Thanks but this look like it does not pull any results back for 0 in either column nad not just 0 in both.
here is the selection formula i am using
{CUSTOMER_ORDER_JOIN\.LINE_STATE} <> "Cancelled" and
{FORECAST_DAY_PUB\.START_DATE} = ( if DayOfWeek (currentdate) in 2 to 7
then currentdate - DayOfWeek (currentdate)+2
else currentdate + 1) and
{FORECAST_DAY_PUB\.PART_NO} startswith "4" and ({VENDOR_MANAGEMENT.ON_HAND_STOCK}<>0 and
{@forecast week2}<>0)
in the last line:
({VENDOR_MANAGEMENT.ON_HAND_STOCK}<>0 and
{@forecast week2}<>0)
it doesn't make any difference if I have the brackets around it or not it still treats them as individual statements.
IP Logged
