Kbase P35706: How to migrate Report Builder reports from Progress version 7 on Progress version 9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/10/2009 |
|
Status: Verified
GOAL:
How to migrate Report Builder reports from Progress version 7 on Progress version 9
GOAL:
What are the steps to use a Report Builder .prl from Progress version 7 on Progress version 9
FACT(s) (Environment):
Windows
Progress 7.3E
Progress 9.x
Report Builder
FIX:
A v9 client cannot connect to a version database. It is possible, however, to connect from a v9 Report Builder to a .prl created by a v7 Report Builder and use the reports in that .prl against a version 9 database.
For this to succeed the v9 database that the v7 report should run against needs to contain the tables and fields required by that report.
If the v9 report is required to access data contained in a v7 database, that database will first have to be migrated to v9.
Steps for accessing the prl:
1. Backup the v7 prl file.
2. Access the v7 with the v9 Report Builder and try to run the report - you will get a version mismatch error:
Unable to connect to database.
** Database has the wrong version number. (db: <value>, pro: <value>). (44)
3. A prompt asking which database will be connected. For the v9 database specify the same logical name as was specified for the v7 database that the report previously ran against. You should then be able to connect and run the report.
4. Ensure that when saving the v9 report that the report is saved into a new prl file, so that the original v7 report and v7 prl isn't overwritten.