Release 10.1A: OpenEdge Reporting:
Deploying Crystal Reports

> ## Adding a new data source

> Once you have created your sample database and determined the proper isolation level, you can proceed to configure the ODBC Client.

> | To configure the ODBC client:

> 1. From the Windows Start menu, choose Settings Control Panel Administrative Tools. The Administrative Tools dialog box appears:

> 2. Double-click Data Sources (ODBC) in the Control Panel dialog box:

> 3. The ODBC Administrator displays the ODBC Data Source Administrator dialog box:

> 4. Click Add to display a list of installed drivers. The Create New Data Source dialog box appears:

> 5. Highlight the DataDirect 4.20 32-BIT Progress SQL v10.0BIP driver, then click Finish to display the ODBC Progress SQL-92 Driver Setup dialog box:

> 6. Specify values for the following:

> - Data Source Name — Identifies data source configuration name. For example, Accounting.
> - Description — An optional long description of the data source name. For example, My Accounting Database.
> - Host Name — The name of the system where the database or database broker is located.
> - Port Number — The system port number setup for the database listener process.
> - Database Name — The name of the database to which you want to connect by default.
> - User ID — The user name used to connect to your OpenEdge database. Your ODBC application can override this value, or you can override it in the Logon dialog box or connection string.
> 7. Click the Advanced tab and specify values for the following:

> - Default isolation level — use `READ UNCOMMITTED`.
> - Fetch array size — The number of rows the driver retrieves when fetching from the server. This is not the number of rows given to the user. The default is 50. Enter 500.
> 8. Click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box. the Driver Setup dialog box will display a logon dialog box:

> 9. Enter your user identification and password and Click OK.The OpenEdge SQL driver displays a message box that states the ODBC driver has successfully connected to the database:

> Now that you have created a sample database, configured your ODBC driver and established a connection to it, you can use Crystal Reports to create a report using the sample database.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095