HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Multi-pass Reporting 

Multi-pass reporting means that you create multiple reports, each one
used as a source file for the next report.  In some cases, this process
improves performance because the database is not re-read for every
interim report.

You can use multi-pass reporting:

   *   To create exception reports; that is, you can execute an HP
       ALLBASE/BRW report and write records that exceed certain values to
       an output file, and then use the file holding these exceptions in
       another HP ALLBASE/BRW report.

   *   To create database extraction files for later fast access to a
       subset of data.

   *   To bundle a series of reports for better performance.

   *   To integrate reports with application batch programs.


          Multi-pass Reporting Flowchart 

This figure shows an example of multi-pass reporting using an output
file.

MPE/iX 5.0 Documentation