Parameter trouble

[raja2008]

Hello Everyone!

I'm using Crystal Reports XI.
I have a parameter on the field Summary which is a string.
When i use the parameter in the select expert it brings me nothing.

I use the parameter like this
table.summary like "*{?summary}*" and it brings me nothing.
when i use the same word that i'm going to search for with the parameter in the select expert it works.
table.summary like "*word*"

Please help.

 

[lbass]

With parameters, you have to use:

{table.summary} like "*"+{?summary}+"*"

-LB

 

[kskid]

keep in mind case sensitivity as well

uppercase({table.summary}) like "*"+uppercase({?summary})+"*"

 

[raja2008]

Thank you verymuch guys.
It worked.