How to Filter a DataBand Using a User-Entered Partial Name

[skilletvivid]

I’m trying to create a report where the user can enter part of a company name and use that value to filter the results.

I created a string variable called SearchName and configured it to accept input from the user. What expression should I use in the DataBand filter to compare this value with the CompanyName column using a LIKE search?

For example, if the user enters only part of a company name, I want the report to display all companies whose CompanyName contains that text.

I’ve tried expressions such as:

SearchName.Contains(CompanyName)

and

CompanyName.Contains(SearchName)

but neither one produces the expected results.

I already know how to filter by selecting a predefined value from a list, but in this case, I need the user to be able to manually enter a partial company name and find all matching records.

What would be the correct filter expression or approach for this?

[Lech Kulikowski]

Hello,

You need to use the following expression:
DataSourceName.ColumnName.Contains(VariableName)

Thank you.