Release 10.1A: OpenEdge Reporting:
Report Builder Deployment

> ## 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095