Operation Manual

Introduction to Reporting
Choosing data sources and database fields
6
84 Crystal Reports User’s Guide
The Create New Connections folder contains subfolders for many popular
data sources. Among these, you’ll find:
• Access/Excel (DAO)
• Database Files
• ODBC (RDO)
• OLAP
• OLE DB (ADO)
Note: The data source options available in the Create New Connections
folder depend on the data access components selected during installation.
For a brief description of each of these folders and subfolders, see “Selecting
the data source” on page 94.
Shortcut Menu
You can right-click any item in the Available Data Sources list of the Database
Expert to see a shortcut menu with the following options:
• Add to Report
Use this option to add a table or stored procedure to your new report.
This option is also available by clicking the > arrow on the Database
Expert.
• Add to Favorites
Use this option to add a selected data source to the Favorites folder.
• Remove from Report
Use this option to remove a table or stored procedure from your report.
This option is also available by clicking the < arrow on the Database
Expert.
• Properties
Use this option to obtain detailed information on the selected item.
• Rename Favorite
Use this option to rename a data source in the Favorites folder.
• Delete Favorite
Use this option to remove a data source from the Favorites folder.
• Remove from repository
Use this option to delete an existing SQL command from the
BusinessObjects Enterprise Repository.