I am working on a SOP Blank Invoice modification, adding a conditional calculated field. In the conditional field I have the following logic. If true it displays one set of text, if not another.
(SOP_Document_HDR_TEMP.DOC Number >= "SWI-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "SWI-9999999999" and RM_Customer_MSTR.Country Code = "CA") OR
(SOP_Document_HDR_TEMP.DOC Number >= "WEB-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "WEB-9999999999" and RM_Customer_MSTR.Country Code = "CA") OR
(SOP_Document_HDR_TEMP.DOC Number >= "INT-0000000000" and SOP_Document_HDR_TEMP.DOC Number <= "INT-9999999999" and RM_Customer_MSTR.Country Code = "CA")
The conditional works when evaluating the first or second clause, but the third clause with the "INT-" invoice does not. The supporting data and syntax is valid. My question is does Report Writer support the three "OR" options? Please advise. Looking for some feedback and advice. Thank you.