Page Comparison

...

1. Open a new Crystal Report.

2. On the Crystal Report Start page, click Blank Report under the New Reports section.
   You see the Database Expert dialog box.

3. Expand the Create New Connection folder and click OK.
   You see the Access/Excel (DAO) dialog box.

4. From the Database Type drop-down list, select Access and click Finish.

5. Expand the table node of the .MDB connection to see the list of tables.

6. Select all the tables you want for the report and click OK.
   You see the Crystal Report Designer dialog box appears.

7. On the View menu, click Field Explorer.
   You see the Field Explorer window, displaying all the tables with the fields you selected. You can expand the Database Fields node in Field Explorer to see the fields in the table.

   Image RemovedImage Added

8. Right-click the field and select Browse Data.
   You see the subset of the values for the field and field type and size.

9. Drag the fields you want to appear on the report.

10. Click the Preview tab to preview the report.

11. Click the Design tab to return to the design section.
    If you see x$# characters instead of field names, click Options on the File menu. On the Layout tab, click Show Field Names.

12. Save the report file with the .RPT extension.

...

1. On the Insert menu, click Insert Group.
   You see the Insert Group dialog box.

   Image RemovedImage Added

2. Select the group and the sorting order for the report data, and then click OK.

...

1. Click the Preview tab.

2. On the Report menu, click Record Sort Expert.
   You see the Record Sort Expert dialog box.

   Image RemovedImage Added

3. Select the field you want to sort in ascending or descending order and click OK.

...

1. Click the Design tab.

2. On the Insert menu, click Insert Picture.
   You see the Open dialog box.

3. Select the logo.

4. Once the object frame appears, drag the logo where you want it to appear.

5. Click the Preview tab to view the report with the logo.

Create Summary Fields

Summary fields allow you to create formulas.

To create a summary field:

1. Go to the Field Explorer on the Design tab.

2. Right-click the Formula Field, and select New.
   You see the Formula Name dialog box.

   Image Added

3. In the Name field, type a name for the formula and click OK.
   You see the Formula Workshop window. You can define the formula on this window.

4. Click Save to save the formula and close the window.

5. If there is an error in the syntax, a prompt appears. Use the new Formula Field like any other field on the report.

Add a Chart to the Report

To add a chart to the report:

1. On the Insert menu, click Chart.
   You see a chart frame.

2. Drag this object to the report.
   Once you place the object on the report you see the Chart Expert dialog box.

3. Select the fields for both X and Y axes for the Chart. Click the Type tab to select the report type.

4. Click OK to display the chart control on the report.

5. Click the Preview tab to view the chart in the report.

Create a Subreport

To create a Subreport:

1. On the Insert menu, click

Subreport.

You see the Insert Subreport dialog box.

1. Select

Choose an existing report and click OK.