Crystal Reports for Eclipse Designer Guide Addendum

Crystal Reports for Eclipse Designer Guide Addendum
©2007Business Objects.All rights reserved.Business Objects owns the following U.S.patents,which may cover products that are offered and licensed by Business Copyright
Objects:5,555,403;6,247,008;6,289,352;6,490,593;6,578,027;6,768,986;6,772,409;6,831,668;6,882,998and 7,139,766.Business Objects and the Business Objects logo,BusinessObjects,Crystal Reports,Crystal Xcelsius,Crystal Decisions,Intelligent Question,Desktop Intelligence,Crystal Enterprise,Crystal Analysis,Web Intelligence,RapidMarts,and BusinessQuery are trademarks or registered trademarks of Business Objects in the United States and/or other countries.All other names mentioned herein may be trademarks of their respective owners.Business Objects products in this release may contain redistributions of software licensed from third-party contributors.Some of these individual components may
Third-party
Contributors also be available under alternative licenses.A partial listing of third-party
contributors that have requested or permitted acknowledgments,as well as required
notices,can be found at:/thirdparty
Crystal Reports for Eclipse Designer Guide Addendum
Data source connections
Data source connections
Eclipse3.3replaces the Database Explorer view with the Data Source
Explorer view,which provides a new way to create connections.
This topic explains how to connect to a Derby database in Eclipse3.3.It also
describes how to connect to the Xtreme sample database.
You will need to install the Derby Embedded Database before you can
connect to it.For information on how to install the database,please go to
the Apache website:
/derby/
To find the Xtreme.jar file
1.On the Window menu,click Preferences.
2.Expand the Crystal Reports node,and click Engine.
3.Write down the path for the Xtreme.jar file.
To connect to a Derby data source
1.In the Data Source Explorer,right-click Databases and select New.
2.Select the Derby Embedded Database and click Next.
3.Type a name for your connection and click Next.
The Derby Embedded Database dialog box appears.
4.In the Select a driver from the drop-down section,click the browse[...]
button.
The Driver Definitions dialog box appears.
5.Search for the version of Derby that you have installed and click Add.
The New Driver Definition dialog box appears.
6.Select the Derby Embedded JDBC Driver and click OK.
The Edit Driver Definition dialog box appears.
7.Remove the default derby.jar file.
8.Click the Add Jar/Zip button.
Crystal Reports for Eclipse Designer Guide Addendum3
Crystal Reports for Eclipse Designer Guide Addendum
Data source connections
9.Browse to the\lib\folder where you installed the Derby files and select
the derby.jar file.
10.In the Properties,modify the following properties:
•Connection URL=
jdbc:derby:jar:(<path to Xtreme.jar>)Xtreme
<path to Xtreme.jar>is the full path to the Xtreme.jar file.
•Database Name=Xtreme
•Password=test
A Password is not required for the connection but in order to add it to
the report,it must be supplied.
•User ID=test
11.Click OK.
12.In the Driver Definitions dialog box,select the Derby Embedded JDBC
Driver and click OK.
13.In the Derby Embedded Database dialog box,ensure the database
location looks like the following value:
jar:(<full path to Xtreme.jar file>)Xtreme
14.Click test connection to verify the connection.
15.Click Finish.
16.In the Databases list,right-click the connection that you created and
select Connect.
The connection will expand and show you the database.If you continue
to expand,you will see the list of tables.
17.To add the tables to the report,you can right-click the table or
drag-and-drop onto a report.
4Crystal Reports for Eclipse Designer Guide Addendum。