mysql odbc in crystal reports 10

1. click on Start > Control Panel > Administrative Tools > Data Sources (ODBC). Configure your settings and click Ok button to proceed. (I’m using jsf_hibernate database for this tutorial)

2. hit Crystal Reports 10 to open report designer

3. create a new crystal report document as a blank report

4. expand ODBC (RDO)

5. select Data Source Name as per-configured earlier

6. key-in userid and password (refer your configuration in MySQL ODBC connector)

7. select table name

8. drag-n-drop table column to design your report

9. preview your report

10. finish – happy designing..

Advertisements

One thought on “mysql odbc in crystal reports 10

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s