Once you have selected a table, you can use the Database Expert dialog box to specify the information to include in your report.
To specify your report information:
1. At the Database Expert dialog box, click + to expand the PUB folder and to view the list of tables located in the PUB schema. Click Customer to highlight it:
Note: Once you select a table to work with, then you identify the columns from which you will extract data for your report. Crystal Reports refers to table columns as data fields.
2. Click > to place Customer in the Selected Tables area and Click OK. The Crystal Reports main dialog box appears:
3. In the Field Explorer area of the Crystal Reports dialog box, click + next to the Database Fields entry to view the list of database tables. Click + next to Customer to view columns (database fields) in the Customer table. For example:
4. Drag and Drop database fields Name, City, and Balance from the Field Explorer to the Details section of the Design tab. The database fields appear in the Details section and the column headers appear directly above the fields in the Page Header section.
