Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

OpenEdge 10.1A
Progress OpenEdge 10.1A driver
Crystal Reports
Windows

SYMPTOM(s):

Attempting to create a report in Crystal Reports

Connection established using ODBC driver supplied with OpenEdge 10.1A

No database tables displayed when expanding PUB schema

Crystal Reports displays the following statement in place of database tables:

...no items found...

Expanding SYSPROGRESS schema shows entries that should normally be displayed under the Stored Procedures node

SYSPROGRESS schema should contain expandable nodes for Stored Procedures and Views

Connection to the database is established as Commands (free-form SQL queries) can be created and return data

CAUSE:

Bug# OE00125503

FIX:

Option #1
Upgrade to OpenEdge 10.1A01 or later

Option #2
Use Commands to replicate tables within the database for report development. For example, create a Command with the statement:

SELECT * FROM pub.customer

Rename the Command to Customer. The Command will then appear in the same way as the normal database table would; fields can be accessed and added to a report normally.
Multiple Commands can be added and renamed and Crystal Reports has the facility to add Links between Commands (for example, customer.custnum -> order.custnum).

Please note that using Commands will incur a performance hit. However, once a fix is available, it would be possible to use the Set Datasource Location... utility to replace the individual Commands with the equivalent database tables (assuming that each Command is configured to represent the whole of a given table, as described above.)