I have the following record selection formula:
not ({TransDetailCustomerView.Route} in [199, 299, 399, 499, 599, 699, 799]) and
(not HasValue({?SUPPLIER}) OR {TransDetailCustomerView.VendorNo} = {?SUPPLIER}) and
not {TransDetailCustomerView.VoidFlag} and
{TransDetailCustomerView.InvoiceDate} = {?DATE RANGE} and
{TransDetailCustomerView.ChainCode} <> 395 and
(if {?LOCATION}= "ALL LOCATIONS" then TRUE
else
{@LOCATION NAMES}={?LOCATION}) and
{TransDetailCustomerView.ServiceType} in [1, 5]
However, when I refresh and preview the report, I get records that are in other service types than 1 or 5. Does anyone know why this would happen?