Kbase P21029: How to override a database connection in the Report Builder Engine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/09/2006 |
|
Status: Unverified
GOAL:
How to override a database connection in the Report Builder Engine
GOAL:
How to change the database connection parameters stored in a report at runtime
GOAL:
How to replace the database connection stored in the report definition with the Report Builder Runtime Engine
GOAL:
How to override a database connection with either the PRINTRB or PRNTRB2 interfaces in the Report Builder Engine
FIX:
Report Builder will store the database connection information that was used when a report was created within the report definition. This information can be overridden at runtime by specifying new database connection parameters in the RB-DB-CONNECTION parameter. Any connection information in this parameter will override the connection information stored in the report definition. For example:
RUN aderb\_printrb(
"c:\dlc\src\aderb\rbsample.prl", /* RB-REPORT-LIBRARY */
"Customer List", /* RB-REPORT-NAME */
"-db sports2000 -H localhost -S 9999 -N TCP", /* RB-DB-CONNECTION */
"", /* RB-INCLUDE-RECORDS */
"", /* RB-FILTER */
"", /* RB-MEMO-FILE */
"D", /* RB-PRINT-DESTINATION */
"", /* RB-PRINTER-NAME */
"", /* RB-PRINTER-PORT */
"", /* RB-OUTPUT-FILE */
0, /* RB-NUMBER-COPIES - zero */
0, /* RB-BEGIN-PAGE - zero */
0, /* RB-END-PAGE - zero */
no, /* RB-TEST-PATTERN */
"", /* RB-WINDOW-TITLE */
yes, /* RB-DISPLAY-ERRORS */
yes, /* RB-DISPLAY-STATUS */
no, /* RB-NO-WAIT */
"", /* RB-OTHER-PARAMETERS */
"status.out"). /* RB-STATUS-FILE */
NOTE: When using either the PRINTRB or PRNTRB2 interfaces, only one database can be overridden with this method. In order to override more databases, the Table interface (_prore) must be used.