Consultor Eletrônico

Status: Verified

FACT(s) (Environment):

Progress 9.1x
OpenEdge 10.x
Crystal Reports
Windows

SYMPTOM(s):

Crystal Report generates error 7484

Sorry, operation not implemented yet (7484)

Report had worked correctly in Progress 9.1x

Queries generated by Crystal for the reports now contain the syntax 'RIGHT OUTER JOIN'

CHANGE:

Upgraded to OpenEdge 10.x

CAUSE:

The error message is valid and correct as Progress SQL-92 does not support RIGHT OUTER JOINs using this syntax (the (+) operator is required); the query generated by Crystal is incorrect for a Progress database.
Crystal Reports needs to be told which style of SQL JOIN syntax to use by setting entries in the Window Registry. Whilst this had been implemented for Progress 9, the name of the ODBC driver .DLL changed in OpenEdge 10 so Crystal was generating SQL statements that could not be executed against a Progress database.

FIX:

For OpenEdge 10.1Bx, add the following entries to the Registry on each PC running Crystal:

Crystal Reports XI
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

Crystal Reports XI R2
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"
For other Progress and OpenEdge and ODBC driver versions, replace the value "PGOE1022" .DLL with the appropriate version as follows:
Progress 9.1D / Merant 3.60 = PGPRO915
Progress 9.1D / DataDirect 4.1 = PGPRO918
Progress 9.1E / DataDirect 4.1 = PGPRO918
OpenEdge 10.0x / DataDirect 4.2 = PGPRO1019
OpenEdge 10.1Ax / DataDirect 5.1 = PGOE1021
OpenEdge 10.1Bx / DataDirect 5.1 = PGOE1022