Found on the Crystal .NET Blog — Sample codes, tips, random rantings on Crystal Reports, Crystal Enterprise etc... —
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 B.b 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 |