BOFocus – Crystal Reports Tips – Tricks – Tutorials

Crystal Reports - Design

Wildcard parameters

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.

Tagged ,

2 thoughts on “Wildcard parameters

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



Use the Chart Sort Order dialog box to sort and group your chart data. This dialog box appears when you click the Order button on the Data tab of the Chart Expert for a chart with the Advanced layout type.