Post Author: vandersee
CA Forum: General
Hello
I'm stuck on what I'm sure should be a simple formula for selecting data using a parameter.
I need to use one parameter to interrogate two fields. In this case I have two fields (company name and surname) and I want the report users to type something in the parameter field (say "SMITH") and the results returned will have "SMITH" as part of either the Company Name or Surname fields or both.
I've tried "({?Company/Surname Name} in {contact.surname}) or {?Company/Surname Name} in {contact.company_name})" as the Selection formula but this seems to ignore the second part of that formula.
Thanks in advance for any help that can be offered.