Kbase P28944: How to change the Database connection information in a Report Builder Report?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/17/2005 |
|
Status: Unverified
GOAL:
How to change the Database connection information in a Report Builder Report?
GOAL:
How to edit the DB Connection information that is stored ina RB Report
FIX:
When a report is built in Report Builder it saves the database connection information and user name within the report.
If this information changes there are two methods by which the connection information can be overridden at run time or reconfigured within the report.
Reconfiguration:
In this method we open Report Builder in the GUI mode and open the report. Since the Database connection information is now different it will notify you that the database cannot be connected to and will prompt you to identify and reconnect to the database. After following the normal connection routine and the report opens, save the report and now the new connection information will be embedded into the report.
NOTE: If you have multiple reports to reconfigure the following steps will save some time;
1) Open Report Builder.
2) Choose OPTIONS -> PREFERENCES from the menu bar.
3) Select the radio set "Prompt Always" at the bottom and the Database connection window will open before it tries to make the connection saved into the report.
Run Time Override:
If you are using Report Builder engine the database connection information can be overridden at runtime. Using the RB-DB-CONNECTION string you can identify the override connection string. For example:
"-db sports2000 -H [hostname] -S [Servicename] -N [connection method]"
NOTE: This will only change the connection information for this generation of the report and the original connection information will still be embedded in the report.
NOTE: Overriding multiple database connections can only be done using the table interface.