Kbase P16812: Report Builder: Can the RBREPORT table of the Report Builder Engine Table Interface be located in th
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/07/2005 |
|
Status: Unverified
GOAL:
Can the RBREPORT table of the Report Builder Engine Table Interface be located in the foreign database when using DataServer products?
GOAL:
Can the RBREPORT table of the Report Builder Engine Table Interface be in an AS/400 or a non-Progress database?
GOAL:
Can the Report Builder Engine RBREPORT table be located in an MS SQL database?
GOAL:
Can the Report Builder Engine RBREPORT table be located in an AS/400 foreign database?
GOAL:
Can the Report Builder Engine RBREPORT table be located in an Oracle database?
FACT(s) (Environment):
Progress 8.3B
Progress 8.3C
Progress 8.3D
Progress 8.3E
Progress 9.x
OpenEdge 10.x
DataServers
FIX:
For versions prior to Progress 8.3B, it is not possible to locate the RBREPORT table in the foreign database. When connecting to more than one database from the command line, Report Builder searches for the RBREPORT table in the first database specified. The first database must therefore be a Progress database (as the foreign database connection takes place AFTER the connection to the Schema Holder database).
From Progress 8.3B and above, it is possible to locate the RBREPORT table when using the Progress/400 and Oracle DataServer products. Please note that it is currently not possible to do this with the MS SQL DataServer, as detailed in P104189.
To achieve this, use the "-rbtabledb" startup parameter to specify the foreign database that contains the RBREPORT table:
SYNTAX:
-rbtabledb <DB Name>
where <DB Name> is the name of the database that contains the RBREPORT table