User`s guide

Viewing Report Alerts..........................................................................................................412
19.2.4
Referring to Report Alerts in formulas..................................................................................413
19.2.5
Using Formulas...................................................................................................................415Chapter 20
Formulas overview...............................................................................................................415
20.1
Typical uses for formulas......................................................................................................415
20.1.1
Formula components and syntax..........................................................................................416
20.2
Formula components............................................................................................................416
20.2.1
Formula syntax.....................................................................................................................417
20.2.2
User Function Libraries in formulas......................................................................................418
20.3
Specifying formulas..............................................................................................................419
20.4
Working with the Formula Workshop....................................................................................420
20.4.1
Working with the Formula Editor...........................................................................................424
20.4.2
Creating and modifying formulas..........................................................................................428
20.5
Creating a formula and inserting it into a report....................................................................428
20.5.1
Creating a formula in the Formula Expert..............................................................................429
20.5.2
Editing formulas....................................................................................................................431
20.5.3
Searching for formula text....................................................................................................431
20.5.4
Copying formulas.................................................................................................................432
20.5.5
Deleting formulas.................................................................................................................434
20.6
Removing the working formula from your report...................................................................434
20.6.1
Deleting the formula specification.........................................................................................434
20.6.2
Debugging formulas.............................................................................................................435
20.7
Debugging evaluation time errors.........................................................................................435
20.7.1
Debugging tutorial................................................................................................................436
20.7.2
Error Messages and Formula Compiler Warnings.................................................................440
20.8
Parameter Fields and Prompts............................................................................................451Chapter 21
Parameter and prompt overview...........................................................................................451
21.1
Parameter field considerations.............................................................................................451
21.1.1
Prompt considerations.........................................................................................................452
21.1.2
Data and non-data parameters.............................................................................................453
21.1.3
Optional parameters.............................................................................................................454
21.1.4
Understanding dynamic prompts..........................................................................................454
21.2
Understanding lists of values................................................................................................457
21.3
List-of-values types..............................................................................................................457
21.3.1
Determining which list-of-values type to use.........................................................................459
21.3.2
Lists of values and prompt groups contrasted......................................................................460
21.3.3
Creating a parameter with a static prompt............................................................................461
21.4
To create a parameter with a static prompt .........................................................................461
21.4.1
2012-03-1414
Contents