Working with interactive filters.............................................................................................223
12.3
To create an interactive filter................................................................................................223
12.3.1
To add additional interactive filters.......................................................................................224
12.3.2
To delete an interactive filter................................................................................................224
12.3.3
Working with lists of values..................................................................................................225
12.4
Creating a parameter with a static list of values....................................................................225
12.4.1
Creating a parameter with a dynamic list of values...............................................................226
12.4.2
Creating a cascading parameter group.................................................................................227
12.4.3
Using separate value and description objects.......................................................................228
12.4.4
To delete a parameter..........................................................................................................229
12.5
Advanced parameter features..............................................................................................229
12.6
To create a parameter that allows multiple values.................................................................229
12.6.1
To enable Select Values Only From List...............................................................................229
12.6.2
Creating a parameter that allows a discrete value or a range of values.................................230
12.6.3
To create a parameter with a hidden prompt........................................................................231
12.6.4
Creating a list of values filter................................................................................................232
12.6.5
To incorporate a parameter into a formula............................................................................233
12.6.6
Defining entry type and format using the Edit Mask..............................................................233
12.6.7
Null handling........................................................................................................................234
12.6.8
Formulas.............................................................................................................................235Chapter 13
Formulas overview...............................................................................................................235
13.1
Typical uses for formulas......................................................................................................235
13.1.1
Formula components............................................................................................................236
13.2
Specifying formulas..............................................................................................................237
13.3
Working with the Formula Workshop....................................................................................237
13.4
Accessing the Formula Workshop........................................................................................238
13.4.1
Navigation panel (Formula Workshop)..................................................................................238
13.4.2
Objects panel (Formula Workshop)......................................................................................238
13.4.3
Formula text window............................................................................................................239
13.4.4
Formula Workshop buttons..................................................................................................239
13.4.5
Creating and modifying formulas..........................................................................................241
13.5
Creating a formula................................................................................................................241
13.5.1
To edit formulas...................................................................................................................242
13.5.2
To search and replace text...................................................................................................242
13.5.3
Deleting formulas.................................................................................................................242
13.5.4
Debugging formulas tutorial..................................................................................................243
13.6
About this tutorial.................................................................................................................243
13.6.1
Error Messages and Formula Compiler Warnings.................................................................248
13.7
Creating Formulas with Crystal Syntax.................................................................................258
13.8
Crystal syntax overview.......................................................................................................258
13.8.1
2011-05-068
Contents