HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Define Report Screen 

Use this screen to specify global characteristics for your printed
report.


            


            

To define global characteristics for a report 

   1.  Type global characteristic definitions in the appropriate fields.

   2.  Press Enter.

See the following Field Descriptions for details on each field.

Field Descriptions 

Report Specification Password 

Optional.  Password restricting access to the specifications for this
report.

Report Description 

Optional.  Description of the report which is displayed on the Define
Report screen.  Can also print this Report Description using the standard
item REPORT-DESCRIPT.

Report Width 

Maximum width is 300 characters.  Default width is 132.

Number Of Horizontal Pages  

The maximum number of horizontal pages, governed by the following
equation:

     (Number of Horizontal Pages * Page Width) <= 300

HP ALLBASE/BRW tells you if you attempt to have too many horizontal
pages.  The default is 1.

Page Length 

Required.  Maximum number of lines on a page is 999.  The default is 60.

Special Paper 

Optional.  User-defined message requesting that special paper be mounted
on the printer each time the report is printed.  This message appears on
the console at print time.  After mounting and aligning the special
paper, the operator replies that printing can start.

String Sorting Sequence 

The sort-character-set for strings.  The possible entries are:

------------------------------------------------------------------------------------------
|                                                                                        |
|              A               Sort according to the ASCII character set.                |
|                                                                                        |
|              E               Sort according to the EBCDIC character set.               |
|                                                                                        |

|              N               Sort according to the Native Language Rules for the       |
|                              default Native Language.  The default method of sorting   |
|                              and the default Native Language are set in the            |
|                              configuration file (See Chapter 17, under Specification   |
|                              Values and Global Values).                                |
|                                                                                        |
------------------------------------------------------------------------------------------

The default is A for ASCII.

SQL Transaction Isolation Level 

Optional.  The locking strategy for SQL transactions.  For read only
applications, RC (read committed) is the best suited locking strategy.
Consult the HP ALLBASE/SQL Reference Manual for a description of the
other isolation levels (RU = read uncommitted, CS = cursor stability, RR
= repeatable reads).  If this field is left blank, the execution value in
the BRW Configuration File is used.

Use Access of Report 

Optional.  The name of a Report Specification File if you want to use the
access definition of another report.  This lets you generate reports with
a common access definition.

Final Access Table 

Display.  The name of the final access table defined for this report.  If
this field is blank, you cannot define the layout or selection for this
report, because either there is no data access defined, or there is no
unique final access table (that is, the defined tables did not build a
hierarchy.)  To define the tables, use Define Table to get to the Define
Table screen.

Softkeys 

Define Table 

Takes you to the Define Table screen.

Define Lines 

Takes you to the Define Lines screen.  If you select Define Lines, you
are prompted for the lineset you want to define.  Type the lineset level
and type as follows:

   *   The lineset level must be R (Report), P (Page), 1..9 (Break
       Level), or D (Detail).  The Break Level refers to the level of a
       sort item as specified on the Define Breaks screen.

   *   The lineset type must be H (Header) or F (Footer).  If the lineset
       level is D, leave the type field blank.

Define Breaks 

Takes you to the Define Breaks screen.

Define Select'n 

Takes you to the Define Selection screen.

Output File 

Takes you to the Output File screen.

Save Report 

Saves your work.  HP ALLBASE/BRW saves the report specification file
automatically when you exit the program or access another report.  If you
make frequent changes, it is better to use Save Report to save the report
in case of system failure.

MPE/iX 5.0 Documentation