Connecting to DP4 from Crystal Reports

The following instructions are for Crystal Reports Version 5 or thereabouts. The details vary slightly for later versions.

Using Crystal Reports you can create reports based on DP4 data sources, as follows:

1. When creating a new report, in the Choose Database File dialog, click SQL Table... The Log On To Server dialog appears
2. In the SQL Types list, select the DP4 data source you want to report on, and click OK. The Choose SQL Table dialog appears. It lists the DP4 data source's application tables in the SQL Tables list
3. Highlight a table and click OK. The Report Window is opened with a floating dialog containing all the fields from the selected table

You can now build the report as you would any other Crystal Reports report. (To create a report based on more than one table, select Add File to Report from the Database menu.)

If you are using Crystal Reports Version 8 add the following line to the DP4 Configuration file in the [odbc] section (which should be created if necessary):
detect_crystal_reports=0
For information on why this is necessary please consult the following article on the DP4 user group web site: a4000011.htm