HP 3000 Manuals

HP ALLBASE/BRW Tutorial

Exercise 9:Request the Report 

This exercise shows you how to enter values for parameters, and explains
the use of "required" parameters.  This exercise takes 10 minutes.   

When you request the report, BRW streams a job that runs the execution
file to produce the report.  For this report you have two execution
files, one compiled with selection set DIRECTORS, the other with
selection set SALES-MANAGERS. This time, you can restrict the customers
reported using parameters.  Four examples are given, two from each
execution file, one without restrictions, and one with a subset of
customers.

Request the report for directors 

   1.  Type the name of the first execution file (for example,
       DIRECTRS.BRWEXEC) in the Report field.

   2.  Choose  Request Report.

       BRW displays the Request Report screen with the parameter
       information for the directors report.


            

       Look at the parameter CUSTOMER-NO. BRW reads the execution file
       and obtains the names and types of any parameters that you defined
       in the report selection set, and displays them on the Request
       Report screen.

       The Type field indicates the parameter result (or data) type.  In
       this case the parameter is of type "S"--string.

   3.  For this report, leave the Values field blank.

       CUSTOMER-NO is a comparison predicate parameter, so you can enter
       an operator and a value in this field.  However, if you leave the
       Values field blank for a comparison predicate parameter, all
       values are taken.

   4.  Choose  Start Report.

   5.  Respond to the prompts for user, account, group and passwords
       until BRW returns the job number.

       BRW displays the message "Job streamed, Job number is #Jnnn".  The
       Reqest Report screen is still displayed.

Request the directors report with restrictions 

   1.  Type > "000002" in the Values field beside CUSTOMER-NO.

   2.  Start the report again.

Request the report for sales managers 

Now you want to request the report for the execution file compiled with
selection set SALES-MANAGERS.

   1.  Type the name of the second execution file, (for example,
       SALESMAN.BRWEXEC) in the Report field (overwriting DIRECTRS).

   2.  Press Enter.


            

       BRW displays the parameters from the new execution file.  As both
       AREA and CUSTOMER-NO are defined in the selection set
       SALES-MANAGERS, both are displayed on the Request Report screen.

       _________________________________________________________________ 

       NOTE  You can only supply a value for a parameter at run time if
             you include it in a selection set and compile the report
             with that selection set.

       _________________________________________________________________ 

   3.  You do not want to restrict any customers in this run, so just
       press the  Start Report to start the report.


            

       BRW highlights the Values field beside AREA. This is because a
       value is required for this parameter and so you cannot run the
       report without a value for it.

   4.  Type "WESTERN" in the Values field beside AREA.

   5.  Choose  Start Report.

   6.  Respond to the prompts until BRW returns the job number.

Run this report with a subset of customers 

   1.  Type > "000002" in the Values field beside CUSTOMER-NO and Choose  
       Start Report.

   2.  Respond to the prompts until BRW returns the job number.

Further restrict the report 

Test the printing of "!!SUBSET ONLY!!".

   1.  Start the report again with SALES-AREA = "WESTERN" and CUSTOMER-NO
       = "000006".

MPE/iX 5.0 Documentation