Operation Manual

Introduction to Reporting
Creating a new report
6
96 Crystal Reports User’s Guide
• OLE DB (ADO)
This option shows a list of OLE DB providers you have already
configured for use. You can also specify a Microsoft Data Link file to use.
Note: The data source options available in the Create New Connections
folder depend on the data access components selected during
installation.
Adding tables
After selecting the data source, you can add one or more tables to base your
report on.
u
To add a table
1. Choose Database Expert from the Database menu.
The Database Expert dialog box appears.
2. On the Data tab, search for the database you want to use in your report.
See “Selecting the data source” on page 94.
3. In the Available Data Sources list, select the table you want to add to your
report and click the > arrow to add it to the Selected Tables list.
You can insert more than one table at a time by selecting multiple tables,
right-clicking, and choosing Add to Report. You can also drag and drop
tables to the Selected Tables list.
Linking multiple tables
If the report contains data from two or more database tables, they need to be
linked at this point when creating reports.
Note: It isn’t necessary to link tables in reports created from a query or
command because any links required by the data have already been processed.
u
To add and link multiple tables
1. Choose Database Expert from the Database menu.
The Database Expert dialog box appears.
2. On the Data tab, select the tables you want to add to your report. See
“Adding tables” on page 96.
The Links tab appears in the Database Expert.
3. Click the Links tab to display the databases currently available for linking.