Filter Not working when applying LIKE '%STR%'

kutbinahar

filter is not working properly showing error when applying filter :
[Table.Item_Name] Like '%gfg%'


its giving 2 errors

1) BC30201 Expression Expected
2) function 'TOString" shadows an override method in base class


where as if i am applying this filter in binding source its working fine


with regards
kutub

AlexTZ

The filter can be any VALID expression (either in C# or VB.Net - depending on language you have selected in the report options).
Please read about expressions here:
http://fast-report.com/documentation/UserM...expressions.htm

kutbinahar

AlexTZ wrote: »

The filter can be any VALID expression (either in C# or VB.Net - depending on language you have selected in the report options).
Please read about expressions here:
http://fast-report.com/documentation/UserM...expressions.htm

i checked and it is working everywhere else except fast reports!!

ok gimme a example how can i apply filter for searching all item names which contains the word "PSP" if the field of item is [TABLE.ITEMNAME]

gimme both example in vb and c#


with regards
kutbi nahar

AlexTZ

Once again. The filter is an expression written in c# or vb.net (you choose the language in the Report|Options... menu). The filter IS NOT a SQL expression or something like that.

There is no "Like" operator in C# or VB.Net. You cannot use it in an expression. Use string class methods such as StartsWith, EndsWith, Contains. Here is the correct filter expression:

[Table.Item_Name].Contains("gfg")

AlexTZ

upd: sorry, my VB is not good - there is Like operator in it.
This should work:

[Table.Item_Name] Like "%gfg%"

kutbinahar

AlexTZ wrote: »

upd: sorry, my VB is not good - there is Like operator in it.
This should work:

[Table.Item_Name] Like "%gfg%"

thanks alex for ur quick reply but this is also not working [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> please provide any working sample where i can apply this type of filter with regards Kutbi Nahar[/img]

AlexTZ

Do you need to filter strings that contain "gfg" inside?
According to MSDN, you have to use the following pattern:

[Table.Item_Name] Like "*gfg*"

kutbinahar

AlexTZ wrote: »

Do you need to filter strings that contain "gfg" inside?
According to MSDN, you have to use the following pattern:

[Table.Item_Name] Like "*gfg*"

see at the bottom it is giving error like this i tried all valid method did you tried at your side for filtering with LIKE expression m shock that NONE of USER OF FAST REPORT IS USING LIKE Expression for filtering !!!!


this is the error image

AlexTZ

Here is the working report, you can run it in the demo.exe program.

AlexTZ

ps: did you noticed I'm using DOUBLE QUOTES?

[Table.Item_Name] Like "*gfg*" --> correct
[Table.Item_Name] Like '*gfg*' --> error

kutbinahar

AlexTZ wrote: »

Here is the working report, you can run it in the demo.exe program.

thanks alex

but i am lil shocked i created a new report from scratch and it worked but why it not worked in previous i think may be i have changed the script language again and again anyways it solved my probs

thanks

with regards

Landene

Many thanks for it..It really helps a lot..

Regards

Landene
Surendettement