Creating reports and dashboards | Stimulsoft community forum

How can I request a Variable from the user and then execute the filter LIKE the supplied Value?

So, I create a string variable 'SearchName' and set to request from user, what do I need to put in the filter in the databand on the report to filter the CompanyName column?

I have tried SearchName.Contains(CompanyName) and CompanyName.Contains(SearchName) neither work. I know how to do this picking a value from a list, but I want the user to be bale to type a partial name and find matches.

Thanks

Hello,

You can use the following expression:
ToLowerCase(DataSourceName.ColumnName).Contains(ToLowerCase(VariableName))

Thank you.