Crystal Reports allows you to connect to a data source such as Derby via JDBC. The following document from Crystal Reports explains the process in details: http://support.businessobjects.com/communityCS/TechnicalPapers/cr_xi_jdbc_connections.pdf
This document explains how to connect to SQL Server using JDBC. Connecting to Derby is very similar. Note that the JDK and Derby JDBC driver come as part of Aware IM installation.
Basically you need to modify the Crystal Reports CRConfig.xml file to include Derby parameters:
1) Point <JavaDir> parameter to AwareIMRoot/JDK/bin:
<JavaDir>C:\AwareIM\JDK\bin</JavaDir>
2) Add AwareIMRoot/Tomcat/shared/lib/derby.jar to the <ClassPath> parameter (this is Derby JDBC driver):
<ClassPath>...;c:\AwareIM\Tomcat\shared\lib\derby.jar
3) Modify <JDBCURL> parameter to point to Derby URL:
<JDBCURL>jdbc:derby:BASDB</JDBCURL>
(to connect to the main data) or
<JDBCURL>jdbc:derby:BASDBTEST</JDBCURL>
(to connect to the test data in testing mode)
4) Modify <JDBCClassName> parameter:
<JDBCClassName>org.apache.derby.jdbc.EmbeddedDriver</JDBCClassName>
Then you will be able to create a report with a data source pointing to the Derby database. When selecting the data source in the Crystal Reports environment choose JDBC/JNDI
