Skip to Content
0
Former Member
Dec 07, 2011 at 02:15 PM

Record Selection Issue

28 Views

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?