Application Specific Problems

Query Builder Registry Settings

Found on the Crystal .NET Blog — Sample 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 Key	String	List of drivers that...	Syntax, if applicable
SQLServerJoinBuilder?	201	support SQL Server ANSI join syntax	FROM A LEFT OUTER B ON A.a B.b
InformixJoinBuilder?	202	support Informix join syntax	FROM A, OUTER B WHERE A.a B.b
OracleJoinBuilder?	203	support Oracle join syntax	FROM 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
DB2JoinBuilder	206	support DB2 ANSI join syntax	FROM A LEFT OUTER B ON A.a B.b
LotusNotesJoinBuilder?	207	support Lotus Notes join syntax	inner joins — FROM A, B WHERE A.a B.b left outer joins — FROM A LEFT OUTER B ON A.a B.b right outer joins — FROM B LEFT OUTER A ON A.a B.b
StarEqualJoinBuilder?	208	support Sybase Star-Equal join syntax	FROM A, B WHERE A.a * B.b

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

Registry Key	String	List of drivers that...	Syntax, if applicable
SQLServerNameBuilder?	301	support SQL Server naming conventions	"<StoredProcedureName?>";<Number>
InformixNameBuilder?	302	support Informix naming conventions	Table 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 conventions	Quotations are allowed in table names and kept as they are
DB2NameBuilder	306	support DB2 naming conventions

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

Registry Key	String	List 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 Key	String	List of drivers that...	Syntax, if applicable
Dot	604	use dot as qualifier separator character	.
AtSign?	605	use At sign as qualifier separator character	@
Colon	606	use colon as qualifier separator character	:

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

Registry Key	String	List of drivers that...	Syntax, if applicable
SQLServerValueBuilder?	401	support SQL Server value building conventions	Unicode strings prefixed with "N"
SQLServer65ValueBuilder	402	support SQL Server 6.5 value building conventions	Unicode strings are not prefixed with "N"
InformixValueBuilder?	403	support Informix value building conventions	Boolean values are 'T' and 'F'
OracleValueBuilder?	404	support Oracle value building conventions	Using TO_DATE function to convert date to string
OracleValueBuilder2?	405	support Oracle value building conventions	Unicode strings are prefixed with "N"
SybaseValueBuilder?	406	support Sybase value building conventions	Unicode strings are prefixed with "N"
AccessValueBuilder?	407	support Access value building conventions	Boolean values are 'TRUE' and 'FALSE'
DAOAccessValueBuilder?	408	support DAO Access value building conventions	Wild cards are * and ?
DB2ValueBuilder	409	support DB2 value building conventions

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

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

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

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

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

Registry Key	String	List 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 syntax	EXECUTE PROCEDURE <procedure name>(<parameters list>)
OracleStoredProcedureClauseBuilder?	704	support Oracle calling syntax	BEGIN <procedure name>(<parameters list>) END
SybaseStoredProcedureClauseBuilder?	705	support Sybase procedure calling syntax	EXEC <procedure name> <parameters list>
AccessStoredProcedureClauseBuilder?	706	support Access stored procedure calling syntax
DB2StoredProcedureClauseBuilder	707	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 Key	String	List 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 Key	String	List of drivers that...	Syntax, if applicable
SybaseWhereClauseBuilder?	1001	support Sybase where clause building conventions