Kbase 18587: How To Override 2 Databases - Report Engine, Table Interface
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How can a Report, with Report Builder that is created against two databases, be overwritten within the report engine?
FIX:
DO TRANSACTION:
CREATE RBREPORT.
ASSIGN RBREPORT.RB-REPORT-LIBRARY = "D:\work\wrk83\REPORTS.prl"
RBREPORT.RB-REPORT-NAME = "connect"
RBREPORT.RB-DB-CONNECTION = "testdb1 => testdb3~ntestdb2 =>
testdb4
RBREPORT.RB-PRINT-DESTINATION = "D"
RBREPORT.RB-PRINTER-NAME = ""
RBREPORT.RB-DISPLAY-STATUS = yes
RBREPORT.RB-DISPLAY-ERRORS = yes.
RELEASE RBREPORT.
END.
/* Display report and delete record */
RUN aderb\_prore(false,
"-db testdb3 -S srv1 -H PC-XXXX -N tcp -db testdb4 -S srv2
-N tcp -H PC-XXXX -rbdel").
You may put the database information in a .pf file.
connect.pf
-db testdb3 -S srv1 -H PC-XXXX -N tcp
-db testdb3 -S srv2 -H PC-XXXX -N tcp
and your command line would be:
RUN aderb\_prore(false,"-pf connect.pf -rbdel")