Hi there,

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 INCLUDES &Keywords.(OR(, |FORMAT=A100)).Keywords:.;


Thank you
Glen

This message has been edited. Last edited by: FP Mod Chuck,

WHERE Comments CONTAINS &Keywords.(OR(, |FORMAT=A100)).Keywords:.;

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]