Greatly increase the flexibility and effciency of your reports by using a wildcard parameter. This nifty trick can be quite useful when you’re searching through textual fields for a specific text pattern.
1. Create a new String parameter and set your default value ‘ALL’ for parameter.
2. Add the following statement to Select Expert:
If {?WildCard} = “ALL” then {your_database_field} like {?Wildcard} & “*”
Special thanks to Sulmar assistance on this tip.
IMHO, better solution is:
if {?WildCard} ’ALL’ then {Your_DatabaseField} like {?Wildcard} & ‘*’
I agree Sulmar… Thanks for the feedback.. I’ll go ahead and make the changes