Kbase 13957: Report Builder - How to override database connection information
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
Example of overriding the database connection information that is saved in the report definition with a database on the network.
FACT(s) (Environment):
Report Builder
Progress 8.x
Progress 9.x
FIX:
This is useful in situations where the database used in development does not have the same name and/or location as the database used in production.
DEF VAR RP-DB-CONNECTION AS CHARACTER INITIAL "".
/* RP-DB-CONNECTION */
/* 1 - Leave blank to use the db connection info saved */
/* in the report definition */
/* 2 - This example shows how to override the saved */
/* database connection info with a db on network */
/******************************/
/* call Report Builder Engine */
/******************************/
RUN aderb/_printrb.p
("c:\work\reports.prl", /* RB-REPORT-LIBRARY */
"Customer List", /* RB-REPORT-NAME */
"-db sports -H newalr -S demosv1 -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 */
1, /* RB-NUMBER-COPIES */
0, /* no quotes */ /* RB-BEGIN-PAGE */
999, /* no quotes */ /* RB-END-PAGE */
no, /* RB-TEST-PATTERN */
"", /* RB-WINDOW-TITLE */
yes, /* RB-DISPLAY-ERRORS */
yes, /* RB-DISPLAY-STATUS */
no, /* RB-NO-WAIT */
"") /* RB-OTHER-PARAMETERS */