Kbase P23896: Crystal Reports 9 requires Registry update for Outer Joins
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/30/2010 |
|
Status: Verified
SYMPTOM(s):
Using Crystal Reports 9 with Outer Joins produces syntax error
Failed to open Rowset
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
FACT(s) (Environment):
Crystal Reports 9
Progress 8.3E
Progress 9.1D
Progress 9.1E
OpenEdge 10.0x
MERANT 3.70 32-BIT Progress SQL-89
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
Progress OpenEdge 10.1C driver
Windows
CAUSE:
The Left Outer Join SQL syntax in Crystal Reports 9 is interpreted differently than in previous versions
FIX:
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\9.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="pgpro915"
"SQLServerJoinBuilder"="ISCDRV32, lldriver, crxml15, wsqlodbc, simba, odbcjt16, odbcjt32, oddp, odtss, osiris, wod40w, wod40t, wod50w, wod50t, vfpodbc, sqrdb, sqrdb32, dmbbx, crwbw, n32odbc, qbodbc, qbodbc32, Blint04, IVOING09, enhodbc3, cwbodbc, db2cli, crdb213, crdb214, crdb209, TDATA32, odbcjt16, odbcjt32, qbodbc, qbodbc32, cwbodbc"
"OracleJoinBuilder2"=""
"InformixJoinBuilder"="crinf913, QEINF506, QEINF507, qeinf509, qeinf709, crinf506, crinf507, crinf509, crinf709, crinf11, crinf12, ivinf506, ivinf507, ivinf509, ivinf709, ixinf709, generic_inf7, ivinf11, ivinf12, sginf12"
"SybaseJoinBuilder"="sqlsrv32, sqlsrvr, qess03, qedbf03, qetxt03, qexls03, crss03, crdbf03, crtxt03, crxls03, qepdx03, QMDBF03, crtxt04, crxls04, crss04, QEIDP06, QEBTR06, crsyb04, crsyb07, crsyb08, crsyb09, crsyb11, crsyb12, SYIQNT, syiqnt, ivtxt12, ivsyb12, crdbm07, crdb207, crdb211, crdb212, crxls507, crxls07,crss07, crss09, c