Author: mcbrown
Date: 2006-11-10 18:26:02 +0100 (Fri, 10 Nov 2006)
New Revision: 3908
Log:
C/ODBC changes:
- Adding note on direct linking under Unix/Linux
- Adding Crystal Reports example
Added:
trunk/refman-4.1/images/myodbc-crystal-1.png
trunk/refman-4.1/images/myodbc-crystal-2.png
trunk/refman-4.1/images/myodbc-crystal-3.png
trunk/refman-4.1/images/myodbc-crystal-4.png
trunk/refman-4.1/images/myodbc-crystal-5.png
trunk/refman-4.1/images/myodbc-crystal-6.png
trunk/refman-5.0/images/myodbc-crystal-1.png
trunk/refman-5.0/images/myodbc-crystal-2.png
trunk/refman-5.0/images/myodbc-crystal-3.png
trunk/refman-5.0/images/myodbc-crystal-4.png
trunk/refman-5.0/images/myodbc-crystal-5.png
trunk/refman-5.0/images/myodbc-crystal-6.png
trunk/refman-5.1/images/myodbc-crystal-1.png
trunk/refman-5.1/images/myodbc-crystal-2.png
trunk/refman-5.1/images/myodbc-crystal-3.png
trunk/refman-5.1/images/myodbc-crystal-4.png
trunk/refman-5.1/images/myodbc-crystal-5.png
trunk/refman-5.1/images/myodbc-crystal-6.png
Modified:
trunk/refman-4.1/connector-odbc.xml
trunk/refman-5.0/connector-odbc.xml
trunk/refman-5.1/connector-odbc.xml
Property changes on: trunk/refman-4.1/images/myodbc-crystal-1.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-4.1/images/myodbc-crystal-2.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-4.1/images/myodbc-crystal-3.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-4.1/images/myodbc-crystal-4.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-4.1/images/myodbc-crystal-5.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-4.1/images/myodbc-crystal-6.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.0/images/myodbc-crystal-1.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.0/images/myodbc-crystal-2.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.0/images/myodbc-crystal-3.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.0/images/myodbc-crystal-4.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.0/images/myodbc-crystal-5.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.0/images/myodbc-crystal-6.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.1/images/myodbc-crystal-1.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.1/images/myodbc-crystal-2.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.1/images/myodbc-crystal-3.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.1/images/myodbc-crystal-4.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.1/images/myodbc-crystal-5.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Property changes on: trunk/refman-5.1/images/myodbc-crystal-6.png
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Modified: trunk/refman-4.1/connector-odbc.xml
===================================================================
--- trunk/refman-4.1/connector-odbc.xml 2006-11-10 17:23:51 UTC (rev 3907)
+++ trunk/refman-4.1/connector-odbc.xml 2006-11-10 17:26:02 UTC (rev 3908)
Changed blocks: 2, Lines Added: 253, Lines Deleted: 0; 9730 bytes
@@ -4618,6 +4618,235 @@
</section>
+ <section id="myodbc-examples-tools-with-crystalreports">
+
+ <title>Using Connector/ODBC with Crystal Reports</title>
+
+ <para>
+ Crystal Reports can use an ODBC DSN to connect to a database
+ from which you to extract data and information for reporting
+ purposes.
+ </para>
+
+ <note>
+ <para>
+ There is a known issue with certain versions of Crystal
+ Reports where the application is unable to open and browse
+ tables and fields through an ODBC connection. Before using
+ Crystal Reports with MySQL, please ensure that you have
+ update to the latest version, including any outstanding
+ service packs and hotfixes. For more information on this
+ issue, see the
+ <ulink
+ url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”">Business
+ Objects Knowledgebase</ulink> for more information.
+ </para>
+ </note>
+
+ <para>
+ For example, to create a simple crosstab report within Crystal
+ Reports XI, you should follow these steps:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Create a DSN using the <literal>Data Sources
+ (ODBC)</literal> tool. You can either specify a complete
+ database, including username and password, or you can
+ build a basic DSN and use Crystal Reports to set the
+ username and password.
+ </para>
+
+ <para>
+ For the purposes of this example, a DSN that provides a
+ connection to an instance of the MySQL Sakila sample
+ database has been created.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Open Crystal Reports and create a new project, or an open
+ an existing reporting project into which you want to
+ insert data from your MySQL data source.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Start the Cross-Tab Report Wizard, either by clicking on
+ the option on the Start Page. Expand the <guilabel>Create
+ New Connection</guilabel> folder, then expand the
+ <guilabel>ODBC (RDO)</guilabel> folder to obtain a list of
+ ODBC data sources.
+ </para>
+
+ <para>
+ You will be asked to select a data source.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-1.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an Data Source in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ When you first expand the <guilabel>ODBC (RDO)</guilabel>
+ folder you will be presented the Data Source Selection
+ screen. From here you can select either a pre-configured
+ DSN, open a file-based DSN or enter and manual connection
+ string. For this example, the <guilabel>Sakila</guilabel>
+ DSN will be used.
+ </para>
+
+ <para>
+ If the DSN contains a username/password combination, or
+ you want to use different authentication credentials,
+ click <guibutton>Next</guibutton> to enter the username
+ and password that you want to use. Otherwise, click
+ <guibutton>Finish</guibutton> to continue the data source
+ selection wizard.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-2.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an ODBC Data Source in
+ Crystal Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ You will be returned the Cross-Tab Report Creation Wizard.
+ You now need to select the database and tables that you
+ want to include in your report. For our example, we will
+ expand the selected Sakila database. Click the
+ <literal>city</literal> table and use the
+ <guibutton>></guibutton> button to add the table to the
+ report. Then repeat the action with the
+ <literal>country</literal> table. Alternatively you can
+ select multiple tables and add them to the report.
+ </para>
+
+ <para>
+ Finally, you can select the parent
+ <guilabel>Sakila</guilabel> resource and add of the tables
+ to the report.
+ </para>
+
+ <para>
+ Once you have selected the tables you want to include,
+ click <guibutton>Next</guibutton> to continue.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-3.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an tables in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ Crystal Reports will now read the table definitions and
+ automatically identify the links between the tables. The
+ identification of links between tables enables Crystal
+ Reports to automatically lookup and summarize information
+ based on all the tables in the database according to your
+ query. If Crystal Reports is unable to perform the linking
+ itself, you can manually create the links between fields
+ in the tables you have selected.
+ </para>
+
+ <para>
+ Click <guibutton>Next</guibutton> to continue the process.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-4.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Table links/structure in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ You can now select the columns and rows that you wish to
+ include within the Cross-Tab report. Drag and drop or use
+ the <guibutton>></guibutton> buttons to add fields to
+ each area of the report. In the example shown, we will
+ report on cities, organized by country, incorporating a
+ count of the number of cities within each country. If you
+ want to browse the data, select a field and click the
+ <guibutton>Browse Data...</guibutton> button.
+ </para>
+
+ <para>
+ Click <guibutton>Next</guibutton> to create a graph of the
+ results. Since we are not creating a graph from this data,
+ click <guibutton>Finish</guibutton> to generate the
+ report.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-5.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Cross-tab definition in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ The finished report will be shown, a sample of the output
+ from the Sakila sample database is shown below.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-6.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Cross-tab final report in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ </orderedlist>
+
+ <para>
+ Once the ODBC connection has been opened within Crystal
+ Reports, you can browse and add any fields within the
+ available tables into your reports.
+ </para>
+
+ </section>
+
</section>
<section id="myodbc-examples-programming">
@@ -8108,6 +8337,30 @@
</qandaentry>
+ <qandaentry>
+
+ <question>
+
+ <para>
+ When linking an application directly to the Connector/ODBC
+ library under Unix/Linux, the application crashes.
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ Connector/ODBC 3.51 under Unix/Linux is not compatible
+ with direct application linking. You must use a driver
+ manager, such as iODBC or unixODBC to connect to an ODBC
+ source.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
</qandaset>
</section>
Added: trunk/refman-4.1/images/myodbc-crystal-1.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-4.1/images/myodbc-crystal-2.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-4.1/images/myodbc-crystal-3.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-4.1/images/myodbc-crystal-4.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-4.1/images/myodbc-crystal-5.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-4.1/images/myodbc-crystal-6.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Modified: trunk/refman-5.0/connector-odbc.xml
===================================================================
--- trunk/refman-5.0/connector-odbc.xml 2006-11-10 17:23:51 UTC (rev 3907)
+++ trunk/refman-5.0/connector-odbc.xml 2006-11-10 17:26:02 UTC (rev 3908)
Changed blocks: 2, Lines Added: 253, Lines Deleted: 0; 9730 bytes
@@ -4618,6 +4618,235 @@
</section>
+ <section id="myodbc-examples-tools-with-crystalreports">
+
+ <title>Using Connector/ODBC with Crystal Reports</title>
+
+ <para>
+ Crystal Reports can use an ODBC DSN to connect to a database
+ from which you to extract data and information for reporting
+ purposes.
+ </para>
+
+ <note>
+ <para>
+ There is a known issue with certain versions of Crystal
+ Reports where the application is unable to open and browse
+ tables and fields through an ODBC connection. Before using
+ Crystal Reports with MySQL, please ensure that you have
+ update to the latest version, including any outstanding
+ service packs and hotfixes. For more information on this
+ issue, see the
+ <ulink
+ url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”">Business
+ Objects Knowledgebase</ulink> for more information.
+ </para>
+ </note>
+
+ <para>
+ For example, to create a simple crosstab report within Crystal
+ Reports XI, you should follow these steps:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Create a DSN using the <literal>Data Sources
+ (ODBC)</literal> tool. You can either specify a complete
+ database, including username and password, or you can
+ build a basic DSN and use Crystal Reports to set the
+ username and password.
+ </para>
+
+ <para>
+ For the purposes of this example, a DSN that provides a
+ connection to an instance of the MySQL Sakila sample
+ database has been created.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Open Crystal Reports and create a new project, or an open
+ an existing reporting project into which you want to
+ insert data from your MySQL data source.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Start the Cross-Tab Report Wizard, either by clicking on
+ the option on the Start Page. Expand the <guilabel>Create
+ New Connection</guilabel> folder, then expand the
+ <guilabel>ODBC (RDO)</guilabel> folder to obtain a list of
+ ODBC data sources.
+ </para>
+
+ <para>
+ You will be asked to select a data source.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-1.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an Data Source in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ When you first expand the <guilabel>ODBC (RDO)</guilabel>
+ folder you will be presented the Data Source Selection
+ screen. From here you can select either a pre-configured
+ DSN, open a file-based DSN or enter and manual connection
+ string. For this example, the <guilabel>Sakila</guilabel>
+ DSN will be used.
+ </para>
+
+ <para>
+ If the DSN contains a username/password combination, or
+ you want to use different authentication credentials,
+ click <guibutton>Next</guibutton> to enter the username
+ and password that you want to use. Otherwise, click
+ <guibutton>Finish</guibutton> to continue the data source
+ selection wizard.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-2.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an ODBC Data Source in
+ Crystal Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ You will be returned the Cross-Tab Report Creation Wizard.
+ You now need to select the database and tables that you
+ want to include in your report. For our example, we will
+ expand the selected Sakila database. Click the
+ <literal>city</literal> table and use the
+ <guibutton>></guibutton> button to add the table to the
+ report. Then repeat the action with the
+ <literal>country</literal> table. Alternatively you can
+ select multiple tables and add them to the report.
+ </para>
+
+ <para>
+ Finally, you can select the parent
+ <guilabel>Sakila</guilabel> resource and add of the tables
+ to the report.
+ </para>
+
+ <para>
+ Once you have selected the tables you want to include,
+ click <guibutton>Next</guibutton> to continue.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-3.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an tables in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ Crystal Reports will now read the table definitions and
+ automatically identify the links between the tables. The
+ identification of links between tables enables Crystal
+ Reports to automatically lookup and summarize information
+ based on all the tables in the database according to your
+ query. If Crystal Reports is unable to perform the linking
+ itself, you can manually create the links between fields
+ in the tables you have selected.
+ </para>
+
+ <para>
+ Click <guibutton>Next</guibutton> to continue the process.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-4.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Table links/structure in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ You can now select the columns and rows that you wish to
+ include within the Cross-Tab report. Drag and drop or use
+ the <guibutton>></guibutton> buttons to add fields to
+ each area of the report. In the example shown, we will
+ report on cities, organized by country, incorporating a
+ count of the number of cities within each country. If you
+ want to browse the data, select a field and click the
+ <guibutton>Browse Data...</guibutton> button.
+ </para>
+
+ <para>
+ Click <guibutton>Next</guibutton> to create a graph of the
+ results. Since we are not creating a graph from this data,
+ click <guibutton>Finish</guibutton> to generate the
+ report.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-5.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Cross-tab definition in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ The finished report will be shown, a sample of the output
+ from the Sakila sample database is shown below.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-6.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Cross-tab final report in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ </orderedlist>
+
+ <para>
+ Once the ODBC connection has been opened within Crystal
+ Reports, you can browse and add any fields within the
+ available tables into your reports.
+ </para>
+
+ </section>
+
</section>
<section id="myodbc-examples-programming">
@@ -8108,6 +8337,30 @@
</qandaentry>
+ <qandaentry>
+
+ <question>
+
+ <para>
+ When linking an application directly to the Connector/ODBC
+ library under Unix/Linux, the application crashes.
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ Connector/ODBC 3.51 under Unix/Linux is not compatible
+ with direct application linking. You must use a driver
+ manager, such as iODBC or unixODBC to connect to an ODBC
+ source.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
</qandaset>
</section>
Added: trunk/refman-5.0/images/myodbc-crystal-1.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.0/images/myodbc-crystal-2.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.0/images/myodbc-crystal-3.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.0/images/myodbc-crystal-4.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.0/images/myodbc-crystal-5.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.0/images/myodbc-crystal-6.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Modified: trunk/refman-5.1/connector-odbc.xml
===================================================================
--- trunk/refman-5.1/connector-odbc.xml 2006-11-10 17:23:51 UTC (rev 3907)
+++ trunk/refman-5.1/connector-odbc.xml 2006-11-10 17:26:02 UTC (rev 3908)
Changed blocks: 2, Lines Added: 251, Lines Deleted: 0; 9350 bytes
@@ -4620,6 +4620,233 @@
</section>
+ <section id="myodbc-examples-tools-with-crystalreports">
+
+ <title>Using Connector/ODBC with Crystal Reports</title>
+
+ <para>
+ Crystal Reports can use an ODBC DSN to connect to a database
+ from which you to extract data and information for reporting
+ purposes.
+ </para>
+
+ <note>
+ <para>
+ There is a known issue with certain versions of Crystal
+ Reports where the application is unable to open and browse
+ tables and fields through an ODBC connection. Before using
+ Crystal Reports with MySQL, please ensure that you have update
+ to the latest version, including any outstanding service packs
+ and hotfixes. For more information on this issue, see the
+ <ulink
+ url="http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.asp”">Business
+ Objects Knowledgebase</ulink> for more information.
+ </para>
+ </note>
+
+ <para>
+ For example, to create a simple crosstab report within Crystal
+ Reports XI, you should follow these steps:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Create a DSN using the <literal>Data Sources
+ (ODBC)</literal> tool. You can either specify a complete
+ database, including username and password, or you can build
+ a basic DSN and use Crystal Reports to set the username and
+ password.
+ </para>
+
+ <para>
+ For the purposes of this example, a DSN that provides a
+ connection to an instance of the MySQL Sakila sample
+ database has been created.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Open Crystal Reports and create a new project, or an open an
+ existing reporting project into which you want to insert
+ data from your MySQL data source.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Start the Cross-Tab Report Wizard, either by clicking on the
+ option on the Start Page. Expand the <guilabel>Create New
+ Connection</guilabel> folder, then expand the <guilabel>ODBC
+ (RDO)</guilabel> folder to obtain a list of ODBC data
+ sources.
+ </para>
+
+ <para>
+ You will be asked to select a data source.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-1.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an Data Source in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ When you first expand the <guilabel>ODBC (RDO)</guilabel>
+ folder you will be presented the Data Source Selection
+ screen. From here you can select either a pre-configured
+ DSN, open a file-based DSN or enter and manual connection
+ string. For this example, the <guilabel>Sakila</guilabel>
+ DSN will be used.
+ </para>
+
+ <para>
+ If the DSN contains a username/password combination, or you
+ want to use different authentication credentials, click
+ <guibutton>Next</guibutton> to enter the username and
+ password that you want to use. Otherwise, click
+ <guibutton>Finish</guibutton> to continue the data source
+ selection wizard.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-2.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an ODBC Data Source in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ You will be returned the Cross-Tab Report Creation Wizard.
+ You now need to select the database and tables that you want
+ to include in your report. For our example, we will expand
+ the selected Sakila database. Click the
+ <literal>city</literal> table and use the
+ <guibutton>></guibutton> button to add the table to the
+ report. Then repeat the action with the
+ <literal>country</literal> table. Alternatively you can
+ select multiple tables and add them to the report.
+ </para>
+
+ <para>
+ Finally, you can select the parent
+ <guilabel>Sakila</guilabel> resource and add of the tables
+ to the report.
+ </para>
+
+ <para>
+ Once you have selected the tables you want to include, click
+ <guibutton>Next</guibutton> to continue.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-3.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Selecting an tables in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ Crystal Reports will now read the table definitions and
+ automatically identify the links between the tables. The
+ identification of links between tables enables Crystal
+ Reports to automatically lookup and summarize information
+ based on all the tables in the database according to your
+ query. If Crystal Reports is unable to perform the linking
+ itself, you can manually create the links between fields in
+ the tables you have selected.
+ </para>
+
+ <para>
+ Click <guibutton>Next</guibutton> to continue the process.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-4.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Table links/structure in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ You can now select the columns and rows that you wish to
+ include within the Cross-Tab report. Drag and drop or use
+ the <guibutton>></guibutton> buttons to add fields to
+ each area of the report. In the example shown, we will
+ report on cities, organized by country, incorporating a
+ count of the number of cities within each country. If you
+ want to browse the data, select a field and click the
+ <guibutton>Browse Data...</guibutton> button.
+ </para>
+
+ <para>
+ Click <guibutton>Next</guibutton> to create a graph of the
+ results. Since we are not creating a graph from this data,
+ click <guibutton>Finish</guibutton> to generate the report.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-5.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Cross-tab definition in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ <listitem>
+ <para>
+ The finished report will be shown, a sample of the output
+ from the Sakila sample database is shown below.
+ </para>
+
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="images/myodbc-crystal-6.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <phrase lang="en">Cross-tab final report in Crystal
+ Reports</phrase>
+ </textobject>
+ </mediaobject>
+ </listitem>
+
+ </orderedlist>
+
+ <para>
+ Once the ODBC connection has been opened within Crystal Reports,
+ you can browse and add any fields within the available tables
+ into your reports.
+ </para>
+
+ </section>
+
<section id="myodbc-examples-programming">
<title>Connector/ODBC Programming Examples</title>
@@ -8107,6 +8334,30 @@
</qandaentry>
+ <qandaentry>
+
+ <question>
+
+ <para>
+ When linking an application directly to the Connector/ODBC
+ library under Unix/Linux, the application crashes.
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ Connector/ODBC 3.51 under Unix/Linux is not compatible
+ with direct application linking. You must use a driver
+ manager, such as iODBC or unixODBC to connect to an ODBC
+ source.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
</qandaset>
</section>
Added: trunk/refman-5.1/images/myodbc-crystal-1.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.1/images/myodbc-crystal-2.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.1/images/myodbc-crystal-3.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.1/images/myodbc-crystal-4.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.1/images/myodbc-crystal-5.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
Added: trunk/refman-5.1/images/myodbc-crystal-6.png
===================================================================
Changed blocks: 0, Lines Added: 0, Lines Deleted: 0; 319 bytes
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3908 - in trunk: refman-4.1 refman-4.1/images refman-5.0 refman-5.0/images refman-5.1 refman-5.1/images | mcbrown | 10 Nov |
