Report creation options
- 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.
Shortcut MenuYou 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 Command to Report
Use this option to add a Table object that has been created using an SQL command.Make New Connection
Use this option to create a new connection.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 Connection
Use this option to rename a data source connection.Delete Connection
Use this option to remove a data source connection.Note:
Database connections which have been connected to or referenced in an open report cannot be deleted
The Field Explorer
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 MenuThe Field Explorer's toolbar provides buttons with tool tips and hot-key combinations. You can right-click any item in the tree view to bring up a shortcut menu. The toolbar offers these functions:
Insert to Report
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.New
Use this option to create a formula field, SQL expression field, parameter field or running total field.Edit
Use this option to modify an existing formula field, SQL expression field, parameter field or running total field.Duplicate
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.Rename
Use this option to modify the name of an existing formula field, SQL expression field, parameter field or running total field.Delete
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.
The report design environment
This section is generally used for the report title and other information you want to appear at the beginning of the report.Page Header
This section is generally used for information that you want to appear at the top of each page.Details
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 onGroup Header
This section typically holds the group name field.Group Footer