How to make text search none case sensitive? Please Help!

[Jessie]

I try to search a field "Title".

I set Title as parameter and also set Title as Filters as below:

= Trim(Fields.[Title]) = =Trim(Parameters.Title)
I try to serarch text "developer" and "Developer", it will return different result set.   Why?

I want to it bring the same result set, make the search none case sensitive. How I do this?


I set dateset casesensitive value to False (by default).

Any help will be appreciated.

[Jessie]

I got it. Thanks!

[PatD]

Here's a solution (for the code behind) :

myReport.Filters.Add(

"=CStr(IsNull(Fields.myField, """")).ToUpper()", Telerik.Reporting.Data.FilterOperator.Like, "='%' + CStr(IsNull(Parameters.myParameter, """")).ToUpper() + '%'")

Regards,

PatD