How to use a wildcard in an Expression

Background:

This articles show how to use a wildcard in an expression

Steps to Complete:

1. In your RDL or Page Report, add a TextBox control to the design surface

2. Select the TextBox and goto its Properties

3. Within the TextBox properties, type Johnny Grapeseed into the Value property

4. Go to the Color property and insert the following expression in the property:

=IIF(Value like "*seed", "Red", "Black")

• Once the expression is set in the Color property, click the preview button to view the result