User`s guide

7.1.6 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.
7.2 Using formula templates
7.2.1 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.
7.2.1.1 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")
2012-03-14134
Record Selection