Application Specific Problems

Query Builder Registry Settings

Found on the Crystal .NET BlogSample codes, tips, random rantings on Crystal Reports, Crystal Enterprise etc...



Query Builder Registry Settings

These are the registry settings of querybuilder. The numbers in brackets are the corresponding strings:

HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\JoinBuilder











Registry KeyStringList of drivers that...Syntax, if applicable
SQLServerJoinBuilder?201 support SQL Server ANSI join syntaxFROM A LEFT OUTER B ON A.a

B.b

InformixJoinBuilder?202 support Informix join syntaxFROM A, OUTER B WHERE A.a

B.b

OracleJoinBuilder?203 support Oracle join syntaxFROM A, B WHERE A.a(+)

B.b

OracleJoinBuilder2?204 support Oracle ANSI join syntax except the FULL OUTER join. These drivers use Outer Join Escape Sequence {oj ...} even for inner joins.FROM A LEFT OUTER B ON A.a

B.b

SybaseJoinBuilder?205 support Sybase ANSI join syntax except the FULL OUTER join.FROM A LEFT OUTER B ON A.a

B.b

DB2JoinBuilder206 support DB2 ANSI join syntaxFROM A LEFT OUTER B ON A.a

B.b

LotusNotesJoinBuilder?207 support Lotus Notes join syntaxinner joinsFROM A, B WHERE A.a

B.b

left outer joinsFROM A LEFT OUTER B ON A.a

B.b

right outer joinsFROM B LEFT OUTER A ON A.a

B.b

StarEqualJoinBuilder?208 support Sybase Star-Equal join syntaxFROM A, B WHERE A.a *

B.b

HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder









Registry KeyStringList of drivers that...Syntax, if applicable
SQLServerNameBuilder?301 support SQL Server naming conventions"<StoredProcedureName?>";<Number>
InformixNameBuilder?302 support Informix naming conventionsTable qualifier appears at the beginning of the fully qualified table name
OracleNameBuilder?303 support Oracle naming conventions"<Package Name>"."<Stored Procedure Name>"
SybaseNameBuilder?304 support Sybase naming conventions
AccessNameBuilder?305 support Access naming conventionsQuotations are allowed in table names and kept as they are
DB2NameBuilder306 support DB2 naming conventions


HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder






Registry KeyStringList of drivers that...Syntax, if applicable
DoubleQuotation?601 use double quotations to quote names" "
BackQuotation?602 use back quotations to quote names` `
SquareBracket?603 use square brackets to quote names[ ]


HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder






Registry KeyStringList of drivers that...Syntax, if applicable
Dot604 use dot as qualifier separator character.
AtSign?605 use At sign as qualifier separator character@
Colon606 use colon as qualifier separator character:


HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\ValueBuilder












Registry KeyStringList of drivers that...Syntax, if applicable
SQLServerValueBuilder?401support SQL Server value building conventionsUnicode strings prefixed with "N"
SQLServer65ValueBuilder402support SQL Server 6.5 value building conventionsUnicode strings are not prefixed with "N"
InformixValueBuilder?403support Informix value building conventionsBoolean values are 'T' and 'F'
OracleValueBuilder?404support Oracle value building conventionsUsing TO_DATE function to convert date to string
OracleValueBuilder2?405support Oracle value building conventionsUnicode strings are prefixed with "N"
SybaseValueBuilder?406support Sybase value building conventionsUnicode strings are prefixed with "N"
AccessValueBuilder?407support Access value building conventionsBoolean values are 'TRUE' and 'FALSE'
DAOAccessValueBuilder?408support DAO Access value building conventionsWild cards are * and ?
DB2ValueBuilder409support DB2 value building conventions


HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\OuterJoinEscSeq





Registry KeyStringList of drivers that...Syntax, if applicable
MSOuterJoinEscSeq?501support Microsoft ODBC join escape sequence{oj ...}
NoOuterJoinEscSeq?504do not support any join escape sequence


HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\DateTimeEscSeq






Registry KeyStringList of drivers that...Syntax, if applicable
MSDateTimeEscSeq1?502support Microsoft ODBC date-time escape sequences{ts ...}, {d ...} and {t ...}
MSDateTimeEscSeq2?503support Microsoft Access date-time escape sequence# ... #

HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\StoredProcedureClauseBuilder











Registry KeyStringList of drivers that...Syntax, if applicable
DefaultStoredProcedureClauseBuilder?701 support default procedure calling syntax{CALL <procedure name>(<parameters list>)}
SQLServerStoredProcedureClauseBuilder?702 support Microsoft SQL Server procedure calling syntax.<procedure name> <parameters list>
InformixStoredProcedureClauseBuilder?703 support Informix calling syntaxEXECUTE PROCEDURE <procedure name>(<parameters list>)
OracleStoredProcedureClauseBuilder?704 support Oracle calling syntaxBEGIN <procedure name>(<parameters list>) END
SybaseStoredProcedureClauseBuilder?705 support Sybase procedure calling syntaxEXEC <procedure name> <parameters list>
AccessStoredProcedureClauseBuilder?706 support Access stored procedure calling syntax
DB2StoredProcedureClauseBuilder707 support DB2 stored procedure calling syntax
PSFTStoredProcedureClauseBuilder?708 support PeopleSoft? stored procedure calling syntax


HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\UnicodeConversionOptions




Registry KeyStringList of drivers that...Syntax, if applicable
AlwaysUnicodeConversion?901 always require Unicode strings to be prefixed with "N"

HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\WhereClauseBuilder




Registry KeyStringList of drivers that...Syntax, if applicable
SybaseWhereClauseBuilder?1001 support Sybase where clause building conventions