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

The Left Outer Join includes all records in the primary table that have an exact match in the secondary table but also all records that don’t have a match in the secondary table. The Left Outer and Right Outer joins are useful when creating reports to find participants without information in their record.

ADVERTISMENT