SAP- Lesson 2

•  A currently connected data source.
• An SQL command that has been saved to the BusinessObjects Enterprise Repository.
•  A data source that has been added to your Favorites folder.
•  A recently accessed data source (the Database Expert automatically maintains a list of such data sources for you).
•  An existing data source (for example, a data file residing locally, or an ODBC data source that has already been set up). In the Database Expert, you can also specify links between database tables when you have selected more than one table for your report. The Database Expert is made up of two tabs: the Data tab and the Links tab.

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.

Use this option to add a Table object that has been created using an SQL command.

Use this option to create a new connection.

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.

Use this option to obtain detailed information on the selected item.

Use this option to rename a data source connection.

Use this option to remove a data source connection.

Database connections which have been connected to or referenced in an open report cannot be deleted

Use the Field Explorer dialog box to insert, modify or delete fields on the Design and Preview tabs of Crystal Reports. To see the Field Explorer, select the Field Explorer command from the View menu.

Toolbar and Shortcut Menu

Use this option to add a field to the report. You can insert more than one field at a time by selecting multiple fields, right-clicking, and choosing insert to Report.
Alternatively, to insert a field, you can drag and drop it in the Design or Preview tabs.

Use this option to browse data for a database field, formula field or SQL expression field. This option is called Browse Data.

Use this option to create a formula field, SQL expression field, parameter field or running total field.

Use this option to modify an existing formula field, SQL expression field, parameter field or running total field.

Use this option to make a copy of the formula that you have selected in the Field Explorer. When the copy is created, you can rename it and edit it.

Use this option to modify the name of an existing formula field, SQL expression field, parameter field or running total field.

Use this option to remove a formula field, SQL expression field, parameter field or running total field. You can also select multiple fields, right-click, and choose Delete to remove them all at once.

This section is generally used for the report title and other information you want to appear at the beginning of the report.

This section is generally used for information that you want to appear at the top of each page.

This section is used for the body of the report, and is printed once per record. The bulk of the report data generally appears in this section.

This section is used for information you want to appear only once at the end of the report (such as grand totals) and for charts and cross-tabs that include data for the entire report.

This section usually contains the page number and any other information you want to appear on 

This section typically holds the group name field.

This section generally holds the summary value.