Hi,
I have a parameter, {?Title}, that allows users to enter in a title when running the report. I want to make it so the user can enter in any part of the title, and the select statement will pull out any title that contains the text the user entered. I tried editing the formula in the select expert to be:
- {tablename.TITLE} like {?Title} -- this doesn't return any results unless the user manually enters wildcards (i.e. *) around their text. For example, if they want to see all titles with the word Coach, they have to enter in *Coach*. Just entering Coach doesn't pull out any records.
or
- {tablename.TITLE} like "*" +{?Title} +"*" -- this returns all titles in the database.
The documentation says that I should be able to use wildcards and parameters, but I can't find any examples of cases similar to what I'm trying to do.
Thanks,
Marc
IP Logged
