Adding Fields to a Crystal Report

Previous Topic: Crystal Reports Fields

A database field is a specific field in the ServiceCEO database that can be imported into your report.

Fields generally come from three types of data sources:

Table. The raw data that exists in the ServiceCEO database. Examples include:
- RawCustRecord - all of the fields located in a customer record
- RawServLocRecord - all of the fields located in a Service Location
- RawBillLocRecord - all of the fields stored in a customer's Bill To location
Views. A virtual table that pulls data together from different database tables for ease of use.
Stored Procedures - a pre-compiled collection of SQL statements and optional control-of-flow statements (i.e., variables, conditional expressions, and variable arguments) stored under a name and processed as a unit. For example, in the Work Order report, there are two stored procedures: WorkOrders and WorkOrderItems. A stored procedure can be used to define a SQL query that you can use over and over again.

Tip!

Tip:
If the stored procedure is designed to prompt a user for information on which to base its query, Crystal Reports will prompt you for that information when you select the stored procedure for your report.

To display the fields that are already located in the report, expand the current database fields on the left side of the Design View page under the Database Fields icon.

To add a field to a Crystal Report:

Preview the report you want to edit.
Click Customize. The Design View The Crystal Reports view in which you can edit the report's data. See the Editing Crystal Reports topic for more information. appears.
Expand the Database Fields icon.
Navigate to the field you want to include. Typically, this involves expanding either a table, view, or stored procedure.
Click and drag this field to the location where you would like it to appear on the report.
Click Preview. Your changes appear.
To add additional fields to the report, repeat steps 2-6. You can toggle between the Preview and Design views as necessary by clicking the appropriate button.

Note!

Note:
Each field that is present in the current report will have a check mark added in front of its name in the Field Explorer.

Click Save and Close. For more on saving your report, see the Saving Reports section.

Caution!

Caution:
If you click Close to close the report without first saving your changes, your modifications will be lost! Be sure to save your changes before closing this dialog box. See the Saving Reports section for details.

Next Topic: Formatting Crystal Reports Fields

Back to Reports Table of Contents