Crystal Reports Online Training

Learn Online, Anytime, Anywhere

Step-by-step tutorials and online videos.

Click Here To Learn More »

4.03 Filtering with Wildcards

Filtering with Wildcards

The comparisons Is Like and Is Not Like have two characteristics which require more explanation. The first characteristic is that they let you build a custom list of allowable criteria. This is similar to the comparisons Is One Of and Is Not One Of described previously. As long as a field’s value matches any one of the values in the list, the record is printed.

The second unique characteristic is that you can use wildcard characters to create a search string. Wildcards let you create a group of matching data without being limited by a beginning and ending range. The strings are selected if they fit the pattern’s search criteria.

Search filters use two wildcard characters: ? and *. The ? allows any character to be in that position in the string. For example, let’s say that you want to print a report with all employees with the first name of Brian. You know that Brian is commonly spelled with a “y” as well as with an “i” and you want to find both spellings. The filter “Br?an” would match both spellings. The ? in the third position tells Crystal Reports that you don’t care which letter is used...

Get UNLIMITED Crystal Reports Online Training!

Click Here To Start Your Training!

1500+ Tutorial Pages

Complete Crystal Reports Online Training with over 1,500 pages of better than book quality Crystal Reports tutorials.

Step-by-step Online Videos

Learn at your own pace from the comfort of your home! Pause, rewind and watch online training videos anytime!

Online Community

Members-only community where you can post and answer questions. The community is checked on a regular basis by best selling Crystal Reports book author Brian Bischof to help answer your questions.

Cut & Paste Source Code

Save time with simple cut and paste source code you can use right now in your next report!

Click Here To Start Your Training!