Progress
Report Builder
Deployment Guide


Running a Report with a Simple Filter Override

The rbfilt1.p sample procedure runs the Customer Discount report in the rbsample.prl report library with the specified filter override:

rbfilt1.p
  DO TRANSACTION:
 
/* 1 */ 
  CREATE RBREPORT.  

/* 2 */ 
  ASSIGN 
    RBREPORT.RB-REPORT-LIBRARY = "c:\dlc\src\aderb\rbsample.prl"
    RBREPORT.RB-REPORT-NAME = "Customer Discount"
    RBREPORT.RB-PRINT-DESTINATION = "D"
    RBREPORT.RB-INCLUDE-RECORDS = "O"    
    RBREPORT.RB-FILTER = "IN-RANGE(Order-Line.Discount, 15, 30)"
    RBREPORT.RB-DISPLAY-STATUS = yes
    RBREPORT.RB-DISPLAY-ERRORS = yes.
    
/* 3 */ 
  RELEASE RBREPORT.  

  END.

/* 4 */ 
  RUN aderb\_prore.p(false,
    "-db Runtable -S servername -H hostname -N networktype -rbdel").  

The commented numbers correspond to the following step-by-step descriptions:

  1. Create the RBREPORT record.
  2. Assign values to the record, including the filter override condition.
  3. Explicitly release the RBREPORT record so that Report Engine can use it.
  4. Call _prore to invoke Report Engine and run the report with the filter override. Then use the Report Delete (-rbdel) parameter to delete the record from the Report Engine table when the procedure is done.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095