I am trying to build a report with parameter that contains keywords. And would like to filter a table column. For example, in my report i am displaying account and comments columns. And i have a parameter called keywords that contains 2 lines 'A VETERAN' and 'AN EMPLOYEE'. How would I create the filter so that the reports gets filtered by what keywords were selected?
In SQL, i could do something like: WHERE Comments LIKE '%A VETERAN%' OR '%AN EMPLOYEE%'.
I tried something like this and it did not work. I got an error, "(FOC028) USE INCLUDES/EXCLUDES TEST TO RETRIEVE PARENT RECORDS ONLY".
WHERE Comments CONTAINS &Keywords.(OR(, |FORMAT=A100)).Keywords:.;
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
August 10, 2020, 06:08 PM
vaayu
This works for me so you should be able to run with LIKE unless it doesn't like SPACES [CODE TABLE FILE CAR SUM SALES BY COUNTRY WHERE COUNTRY LIKE '%J%' OR '%Y%' END [/CODE]