I'm trying to create a report which finds all records in the MEMBERS database, which are from CANADA, or MEXICO. Is there a way to perform an OR operation in SETFILTER / ADDFILTER?
This is what I am doing now, and it is returning no records.
Code:
Procedure SetFilters
String sReportId
Send AddFilter sReportId "{members.Country}" C_drEqual "CANADA"
Send AddFilter sReportId "{members.Country}" C_drEqual "Canada"
Send AddFilter sReportId "{members.Country}" C_drEqual "MEXICO"
Send AddFilter sReportId "{members.Country}" C_drEqual "Mexico"
Send AddFilter sReportId "{members.Active}" C_drEqual "YES"
End_Procedure