Wildcard Parameters in Crystal Reports
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_DatabaseField} like '*' else
{Your_DatabaseField} like {?Wildcard} & '*'
| Other Crystal Reports Tips you may find
useful |
|
How to filter, select data |
Storing report samples on your iphone |
|
Formatting dates in crystal reports |
Suppressing blank lines in embedded fields |
About Us
Whether it's a complete automated report system with SAP Crystal Reports and SAP Business Objects Enterprise, or reporting on a single data source.. We can make it happen.
Support
Swansea, Wales
General Mailbox. 07740 890361
Email: bkuipersuk@gmail.com
Connect
