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