Datasheet

Using Formulas...................................................................................................................417Chapter 20
Formulas overview...............................................................................................................417
20.1
Typical uses for formulas......................................................................................................417
20.1.1
Formula components and syntax..........................................................................................418
20.2
Formula components............................................................................................................418
20.2.1
Formula syntax.....................................................................................................................419
20.2.2
User Function Libraries in formulas......................................................................................420
20.3
Specifying formulas..............................................................................................................421
20.4
Working with the Formula Workshop....................................................................................422
20.4.1
Working with the Formula Editor...........................................................................................426
20.4.2
Creating and modifying formulas..........................................................................................430
20.5
Creating a formula and inserting it into a report....................................................................430
20.5.1
Creating a formula in the Formula Expert..............................................................................431
20.5.2
Editing formulas....................................................................................................................433
20.5.3
Searching for formula text....................................................................................................433
20.5.4
Copying formulas.................................................................................................................434
20.5.5
Deleting formulas.................................................................................................................436
20.6
Removing the working formula from your report...................................................................436
20.6.1
Deleting the formula specification.........................................................................................436
20.6.2
Debugging formulas.............................................................................................................437
20.7
Debugging evaluation time errors.........................................................................................437
20.7.1
Debugging tutorial................................................................................................................438
20.7.2
Error Messages and Formula Compiler Warnings.................................................................442
20.8
Parameter Fields and Prompts............................................................................................453Chapter 21
Parameter and prompt overview...........................................................................................453
21.1
Parameter field considerations.............................................................................................453
21.1.1
Prompt considerations.........................................................................................................454
21.1.2
Data and non-data parameters.............................................................................................455
21.1.3
Optional parameters.............................................................................................................456
21.1.4
Understanding dynamic prompts..........................................................................................456
21.2
Understanding lists of values................................................................................................459
21.3
List-of-values types..............................................................................................................459
21.3.1
Determining which list-of-values type to use.........................................................................461
21.3.2
Lists of values and prompt groups contrasted......................................................................462
21.3.3
Creating a parameter with a static prompt............................................................................463
21.4
To create a parameter with a static prompt .........................................................................463
21.4.1
To incorporate the parameter into the record selection filter.................................................465
21.4.2
To incorporate the parameter into a saved data selection formula........................................466
21.4.3
2011-05-1614
Contents