HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

At a Glance 

HP ALLBASE/BRW data selection lets you use these features for flexible,
but secure data selection:

   *   execution parameters

   *   default values for parameters

   *   frozen and required defaults

   *   multiple selection sets

   *   calculation language for complex data selection formulas  

   *   data-value-dependent security provided by multiple selection sets
       and passwords

There are two ways to select data:

For security          You can define data selection when you specify the
                      report so that it becomes an integral part of the
                      report.

For flexibility       You can define data selection with parameters whose
                      values can be selected when the report is requested
                      for execution.

Example 

Suppose you have one report that contains all the information about
company sales for every sales area.  You would like a separate report for
each area.  By creating separate selection sets, you can produce a sales
report for each sales area.


            

After you create one or more selection sets, you can use the Calculation
Language, discussed in Chapter 15 , to specify a condition for data
selection.  The selection condition determines which records (that is,
details) from the final access table are included in the report.

This chapter covers 

   *   selecting data at specification time

   *   selecting data at execution time

   *   using selection conditions

   *   defining parameters

MPE/iX 5.0 Documentation