QueryBuilderRegistrySettings 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 <tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="SQLServerJoinBuilder">SQLServerJoinBuilder</ulink></computeroutput></entry> <entry>201</entry> <entry> support SQL Server ANSI join syntax</entry> <entry><computeroutput>FROM A LEFT OUTER B ON A.a <para> B.b</para></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="InformixJoinBuilder">InformixJoinBuilder</ulink></computeroutput></entry> <entry>202</entry> <entry> support Informix join syntax</entry> <entry><computeroutput>FROM A, OUTER B WHERE A.a <para> B.b</para></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="OracleJoinBuilder">OracleJoinBuilder</ulink></computeroutput></entry> <entry>203</entry> <entry> support Oracle join syntax</entry> <entry><computeroutput>FROM A, B WHERE A.a(+) <para> B.b</para></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="OracleJoinBuilder2">OracleJoinBuilder2</ulink></computeroutput></entry> <entry>204</entry> <entry> support Oracle ANSI join syntax except the FULL OUTER join. These drivers use Outer Join Escape Sequence <computeroutput>{oj ...}</computeroutput> even for inner joins.</entry> <entry><computeroutput>FROM A LEFT OUTER B ON A.a <para> B.b</para></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="SybaseJoinBuilder">SybaseJoinBuilder</ulink></computeroutput></entry> <entry>205</entry> <entry> support Sybase ANSI join syntax except the FULL OUTER join.</entry> <entry><computeroutput>FROM A LEFT OUTER B ON A.a <para> B.b</para></computeroutput></entry> </row> <row> <entry><computeroutput>DB2JoinBuilder</computeroutput></entry> <entry>206</entry> <entry> support DB2 ANSI join syntax</entry> <entry><computeroutput>FROM A LEFT OUTER B ON A.a <para> B.b</para></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="LotusNotesJoinBuilder">LotusNotesJoinBuilder</ulink></computeroutput></entry> <entry>207</entry> <entry> support Lotus Notes join syntax</entry> <entry><emphasis>inner joins</emphasis> — <computeroutput>FROM A, B WHERE A.a <para> B.b <emphasis>left outer joins</emphasis> — <computeroutput>FROM A LEFT OUTER B ON A.a </computeroutput></para><para> B.b <emphasis>right outer joins</emphasis> — <computeroutput>FROM B LEFT OUTER A ON A.a </computeroutput></para><para> B.b</para></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="StarEqualJoinBuilder">StarEqualJoinBuilder</ulink></computeroutput></entry> <entry>208</entry> <entry> support Sybase Star-Equal join syntax</entry> <entry><computeroutput>FROM A, B WHERE A.a *<para> B.b</para></computeroutput></entry> </row> </tbody></tgroup></table><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder</computeroutput></emphasis></para> <table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="SQLServerNameBuilder">SQLServerNameBuilder</ulink></computeroutput></entry> <entry>301</entry> <entry> support SQL Server naming conventions</entry> <entry><computeroutput>"<<ulink url="StoredProcedureName">StoredProcedureName</ulink>>";<Number></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="InformixNameBuilder">InformixNameBuilder</ulink></computeroutput></entry> <entry>302</entry> <entry> support Informix naming conventions</entry> <entry><emphasis>Table qualifier appears at the beginning of the fully qualified table name</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="OracleNameBuilder">OracleNameBuilder</ulink></computeroutput></entry> <entry>303</entry> <entry> support Oracle naming conventions</entry> <entry><computeroutput>"<Package Name>"."<Stored Procedure Name>"</computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="SybaseNameBuilder">SybaseNameBuilder</ulink></computeroutput></entry> <entry>304</entry> <entry> support Sybase naming conventions</entry> <entry /> </row> <row> <entry><computeroutput><ulink url="AccessNameBuilder">AccessNameBuilder</ulink></computeroutput></entry> <entry>305</entry> <entry> support Access naming conventions</entry> <entry><emphasis>Quotations are allowed in table names and kept as they are</emphasis></entry> </row> <row> <entry><computeroutput>DB2NameBuilder</computeroutput></entry> <entry>306</entry> <entry> support DB2 naming conventions</entry> <entry /> </row> </tbody></tgroup></table> <para> </para><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder</computeroutput></emphasis></para><table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="DoubleQuotation">DoubleQuotation</ulink></computeroutput></entry> <entry>601</entry> <entry> use double quotations to quote names</entry> <entry><computeroutput>" "</computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="BackQuotation">BackQuotation</ulink></computeroutput></entry> <entry>602</entry> <entry> use back quotations to quote names</entry> <entry><computeroutput>` `</computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="SquareBracket">SquareBracket</ulink></computeroutput></entry> <entry>603</entry> <entry> use square brackets to quote names</entry> <entry><computeroutput>[ ]</computeroutput></entry> </row> </tbody></tgroup></table> <para> </para><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder</computeroutput></emphasis></para><table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput>Dot</computeroutput></entry> <entry>604</entry> <entry> use dot as qualifier separator character</entry> <entry><computeroutput>.</computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="AtSign">AtSign</ulink></computeroutput></entry> <entry>605</entry> <entry> use At sign as qualifier separator character</entry> <entry><computeroutput>@</computeroutput></entry> </row> <row> <entry><computeroutput>Colon</computeroutput></entry> <entry>606</entry> <entry> use colon as qualifier separator character</entry> <entry><computeroutput>:</computeroutput></entry> </row> </tbody></tgroup></table> <para> </para><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\ValueBuilder</computeroutput></emphasis></para><table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="SQLServerValueBuilder">SQLServerValueBuilder</ulink></computeroutput></entry> <entry>401</entry> <entry>support SQL Server value building conventions</entry> <entry><emphasis>Unicode strings prefixed with "</emphasis><computeroutput>N</computeroutput><emphasis>"</emphasis></entry> </row> <row> <entry><computeroutput>SQLServer65ValueBuilder</computeroutput></entry> <entry>402</entry> <entry>support SQL Server 6.5 value building conventions</entry> <entry><emphasis>Unicode strings are not prefixed with "</emphasis><computeroutput>N</computeroutput><emphasis>"</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="InformixValueBuilder">InformixValueBuilder</ulink></computeroutput></entry> <entry>403</entry> <entry>support Informix value building conventions</entry> <entry><emphasis>Boolean values are '</emphasis><computeroutput>T</computeroutput><emphasis>' and '</emphasis><computeroutput>F</computeroutput><emphasis>'</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="OracleValueBuilder">OracleValueBuilder</ulink></computeroutput></entry> <entry>404</entry> <entry>support Oracle value building conventions</entry> <entry><emphasis>Using </emphasis><computeroutput>TO_DATE</computeroutput><emphasis> function to convert date to string</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="OracleValueBuilder2">OracleValueBuilder2</ulink></computeroutput></entry> <entry>405</entry> <entry>support Oracle value building conventions</entry> <entry><emphasis>Unicode strings are prefixed with "</emphasis><computeroutput>N</computeroutput><emphasis>"</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="SybaseValueBuilder">SybaseValueBuilder</ulink></computeroutput></entry> <entry>406</entry> <entry>support Sybase value building conventions</entry> <entry><emphasis>Unicode strings are prefixed with "</emphasis><computeroutput>N</computeroutput><emphasis>"</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="AccessValueBuilder">AccessValueBuilder</ulink></computeroutput></entry> <entry>407</entry> <entry>support Access value building conventions</entry> <entry><emphasis>Boolean values are '</emphasis><computeroutput>TRUE</computeroutput><emphasis>' and '</emphasis><computeroutput>FALSE</computeroutput><emphasis>'</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="DAOAccessValueBuilder">DAOAccessValueBuilder</ulink></computeroutput></entry> <entry>408</entry> <entry>support DAO Access value building conventions</entry> <entry><emphasis>Wild cards are </emphasis><computeroutput>*</computeroutput><emphasis> and </emphasis><computeroutput>?</computeroutput></entry> </row> <row> <entry><computeroutput>DB2ValueBuilder</computeroutput></entry> <entry>409</entry> <entry>support DB2 value building conventions</entry> <entry /> </row> </tbody></tgroup></table> <para> </para><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\OuterJoinEscSeq</computeroutput></emphasis></para><table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="MSOuterJoinEscSeq">MSOuterJoinEscSeq</ulink></computeroutput></entry> <entry>501</entry> <entry>support Microsoft ODBC join escape sequence</entry> <entry><computeroutput>{oj ...} </computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="NoOuterJoinEscSeq">NoOuterJoinEscSeq</ulink></computeroutput></entry> <entry>504</entry> <entry>do not support any join escape sequence</entry> <entry /> </row> </tbody></tgroup></table> <para> </para><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\DateTimeEscSeq</computeroutput></emphasis></para> <table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="MSDateTimeEscSeq1">MSDateTimeEscSeq1</ulink></computeroutput></entry> <entry>502</entry> <entry>support Microsoft ODBC date-time escape sequences</entry> <entry><computeroutput>{ts ...}</computeroutput>, <computeroutput>{d ...}</computeroutput> <emphasis>and</emphasis> <computeroutput>{t ...}<computeroutput /></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="MSDateTimeEscSeq2">MSDateTimeEscSeq2</ulink></computeroutput></entry> <entry>503</entry> <entry>support Microsoft Access date-time escape sequence</entry> <entry><computeroutput># ... #</computeroutput></entry> </row> </tbody></tgroup></table><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\StoredProcedureClauseBuilder</computeroutput></emphasis></para> <table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="DefaultStoredProcedureClauseBuilder">DefaultStoredProcedureClauseBuilder</ulink></computeroutput></entry> <entry>701</entry> <entry> support default procedure calling syntax</entry> <entry><computeroutput>{CALL <procedure name>(<parameters list>)}</computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="SQLServerStoredProcedureClauseBuilder">SQLServerStoredProcedureClauseBuilder</ulink></computeroutput></entry> <entry>702</entry> <entry> support Microsoft SQL Server procedure calling syntax.</entry> <entry><computeroutput><procedure name> <parameters list></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="InformixStoredProcedureClauseBuilder">InformixStoredProcedureClauseBuilder</ulink></computeroutput></entry> <entry>703</entry> <entry> support Informix calling syntax</entry> <entry><computeroutput>EXECUTE PROCEDURE <procedure name>(<parameters list>)</computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="OracleStoredProcedureClauseBuilder">OracleStoredProcedureClauseBuilder</ulink></computeroutput></entry> <entry>704</entry> <entry> support Oracle calling syntax</entry> <entry><computeroutput>BEGIN <procedure name>(<parameters list>) END</computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="SybaseStoredProcedureClauseBuilder">SybaseStoredProcedureClauseBuilder</ulink></computeroutput></entry> <entry>705</entry> <entry> support Sybase procedure calling syntax</entry> <entry><computeroutput>EXEC <procedure name> <parameters list></computeroutput></entry> </row> <row> <entry><computeroutput><ulink url="AccessStoredProcedureClauseBuilder">AccessStoredProcedureClauseBuilder</ulink></computeroutput></entry> <entry>706</entry> <entry> support Access stored procedure calling syntax</entry> <entry /> </row> <row> <entry><computeroutput>DB2StoredProcedureClauseBuilder</computeroutput></entry> <entry>707</entry> <entry> support DB2 stored procedure calling syntax</entry> <entry /> </row> <row> <entry><computeroutput><ulink url="PSFTStoredProcedureClauseBuilder">PSFTStoredProcedureClauseBuilder</ulink></computeroutput></entry> <entry>708</entry> <entry> support <ulink url="PeopleSoft">PeopleSoft</ulink> stored procedure calling syntax</entry> <entry /> </row> </tbody></tgroup></table> <para> </para><para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\UnicodeConversionOptions</computeroutput></emphasis></para><table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="AlwaysUnicodeConversion">AlwaysUnicodeConversion</ulink></computeroutput></entry> <entry>901</entry> <entry> always require Unicode strings to be prefixed with "N"</entry> <entry /> </row> </tbody></tgroup></table> <para><emphasis><computeroutput>HKLM\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\WhereClauseBuilder</computeroutput></emphasis></para> <table><title /><tgroup><thead /><tbody> <row> <entry><emphasis>Registry Key</emphasis></entry> <entry><emphasis>String</emphasis></entry> <entry><emphasis>List of drivers that...</emphasis></entry> <entry><emphasis>Syntax, if applicable</emphasis></entry> </row> <row> <entry><computeroutput><ulink url="SybaseWhereClauseBuilder">SybaseWhereClauseBuilder</ulink></computeroutput></entry> <entry>1001</entry> <entry> support Sybase where clause building conventions</entry> <entry /> </row> </tbody></tgroup></table> </section></docbook>