Kbase P84577: Crystal Reports 10 and 11 require Registry update for Outer Joins
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/28/2008 |
|
Status: Verified
SYMPTOM(s):
Using Crystal Reports 10 with outer joins produces syntax error
Using Crystal Reports 11 with outer joins produces syntax error
Failed to open Rowset
Syntax error (7587).
Failed to open a rowset.
Details: ADO Error Code: 0x80040e14
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [DataDirect-Technologies][ODBC Progress driver][PROGRESS]Syntax error (7587)
SQL State: 37000
Native Error: -20003
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
Crystal Reports 10
Crystal Reports 11 (XI)
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92 9.1D
DataDirect 4.10 32-Bit Progress SQL92 9.1E
DataDirect 4.20 32-Bit OpenEdge SQL92 10.0A
DataDirect 4.20 32-Bit OpenEdge SQL92 10.0B
Progress OpenEdge 10.1A driver
Progress OpenEdge 10.1B driver
Windows
CAUSE:
When running Progress 9.x and OpenEdge 10 with a Merant/DataDirect driver, the syntax is PlusEqual.
FIX:
Disclaimer:
The information below relates to a third-party product and is derived from Business Objects Knowledge Center articles. It is therefore provided 'as-is'. Customers requiring more information concerning their specific version of Crystal Reports are advised to check the Business Objects Knowledge Center or contact Business Objects Technical Support for further assistance.
To use a .reg file to edit the registry of Crystal Reports 10 with Progress 9.1D:
1. Backup the Registry.
2. Create a text file called "OracleJoinBuilder.txt".
3. Copy the following text into the text file:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"DB2JoinBuilder"="PGPRO915"
"OracleJoinBuilder"="PGPRO915"
4. Rename the text file (TXT) file with the Registry Key file name extension (REG). For example, if the text file name is ?Joinbuilder.txt?, then rename it to ?Joinbuilder.reg?. Or, if the text file name is ?Oraclejoinbuilder.txt?, then rename it to ?Oraclejoinbuilder.reg?.
5. Double-click the REG file to enter the updated Registry Key setting.
Upon completing the above steps, the Registry Key setting on the computer will be updated to include the correct Left-Outer-Join SQL syntax.
NOTE:
The PGPRO** are the SQL-92 drivers. The name changes depending on the driver Version. Please verify which ODBC driver is used by going to the "Drivers" tab of the ODBC Data Source Administrator. At the time of this writing, the possible settings are 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.2 = PGOE1022
OpenEdge 10.1Cx / DataDirect 5.3 = PGOE1023
To Manually edit the registry of Crystal Reports XI with Progress 9.1E:
1. Locate the key:
HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Database\Querybuilder\Joinbuilder
2. Select (Highlight) the key Joinbuilder -> RightMouseClick -> New -> String Value -> Type DB2JoinBuilder
3. Select (Highlight) the key Joinbuilder -> RightMouseClick -> New -> String Value -> Type OracleJoinBuilder
4. Double Click the String Value DB2JoinBuilder and type PGPRO918 in the Vaule data.
5. Double Click the String Value OracleJoinBuilder and type PGPRO918 in the Vaule data.