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>

GET SOCIAL

QUICK TIP

Count should be used whenever you want to know the number of records that have the same information.

Distinct Count should be used whenever you want to know the number of records where the records are unique or different.

ADVERTISMENT