HP Intelligent Management Center Standard Software Platform - Manual (Page 199)

Saved data selection formulas
Saved data selection formulas filter report data after the records have been
stored in the report. Like record selection formulas, they can be created using
both the Select Expert and formulas.
Unlike record selection formulas, any change to a saved data selection
formula does not cause a refresh to the database. Instead, the report's saved
data is used for all subsequent filtering. Saved data selection formulas are
used with parameters to create interactive report filters that you can
customize.
Optional parameters
You can combine saved data selection formulas and optional parameters.
For more information on optional parameters, see
Optional parameters .
Using formula templates
Record selection formula templates
The following sample formulas can be used as templates to help you create
your own selection formulas using the Formula Workshop. These examples
illustrate different selections that you could do, not necessarily the best
selections.
Selecting records using character strings
{file.FIELD} startswith "C"
Selects those records in which the value in the {file.FIELD} field begins with
the character "C" (includes values like CyclePath, Corp. and Cyclist's Trail
Co.; excludes values like Bob's Bikes Ltd. and Feel Great Bikes, Inc.).
not ({file.FIELD} startswith "C")
Crystal Reports 2008 SP3 User's Guide 199
9 Record Selection
Using formula templates