HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Creating a Report 

After you have planned the report to your satisfaction, start HP
ALLBASE/BRW and create the report.

To create a report 

   1.  Start at the Select Report screen (the first screen when you start
       HP ALLBASE/BRW).

       (For instructions on starting HP ALLBASE/BRW, see Chapter 4 ).

   2.  Type the name of the report you want to create in the Report
       field.  This will be the name of the report specification file
       that HP ALLBASE/BRW creates.


            

   3.  Choose  Add Report.

   4.  At the prompt that appears, enter the name of the report form (if
       any) that you want to copy, or press Enter to create a new report.

            Copy from report      or press ENTER.

       The Define Report screen appears.

To define the report 

   1.  Type a password in the Password field if you need security on this
       report.

   2.  Type a report description in the Description field.  The
       description can be anything that will help you identify the
       report.  This field is optional.

   3.  Check the global report characteristics (described in the next
       section) and make sure that they are correct for your report.


            

   4.  Press Enter to record the report description.  The message:
       Report modified appears.

Global Report Characteristics 

On the Define Report screen, there are several global report
characteristics that have a default value already assigned.  These
characteristics are described below to help you select the correct ones
for your report.

Paper Characteristics.   

Paper characteristics are:

   *   Report width (1 - 300)

   *   Page length (1 - 999)

   *   Optional special paper to be used for printing a report such as
       pre-printed check forms.  A message requesting that special paper
       be mounted on the printer is sent to the operator console each
       time the report is printed.  After mounting and aligning the
       special paper, the operator replies that printing can start now
       (see the Console Operators Guide for your system).

   *   Number of Horizontal Pages.  You can set the number of horizontal
       pages for each physical page.  HP ALLBASE/BRW can print a number
       of pages, side-by-side, on one physical page.

String Sorting Sequence.   

You can specify whether to sort strings according to ASCII, EBCDIC or
National Language Rules.  ASCII is fastest.

SQL Transaction Isolation Level.   

This option lets you determine whether other users can modify the table
while you are reading it.  If you allow others to modify the table while
you are reading the data, you may get only partially updated information.
RC (read committed) is the default.  If this field is blank, the
execution value in the BRW Configuration File is used.

Data Access.   

Data access can be defined in either of these two ways:

   *   USE Access by typing the data access definition of another report
       at the Select Report screen (in the USE Access of Report field).

   *   Self-Defined Access by setting up a data access definition within
       the report you are defining at the Define Table screen.

To use the data access of another report 

   1.  Type the specification file name of the other report in the USE
       Access of Report field on the Define Report screen, as shown on
       the following sample screen:


            

   2.  Press Enter.

To set up self-defined data access 

Self-defined data access uses the Tune Access and the Parameter screens
and is discussed in Chapter 6 .

MPE/iX 5.0 Documentation