Before you create report designs, you can use Report Manager to generate report sample data. Report Manager creates tables for the sample data in a separate custom reports database based on one or more representative estimates that you select. You can then use the tables and the fields contained in this sample database to set up your report design in Crystal Reports.

Note: Report designer databases are not created automatically for all users. The databases are created only when you generate sample design data.

After creating the sample data, you can create any number of report designs that will extract data from the same custom report database.

The following steps describe how to create sample data for Crystal Reports report designs.

Before you start

Note: When generating sample data, you must select an existing report design file. If no report file exists in Report Manager, create a blank report design file.

1. Start SAP Crystal Reports.
2. On the Start Pagetab, click Blank report.
3. In the Database Expertwindow that appears, click [Cancel].
4. On the main menu, click File> Save.
5. In the File nametext box, type blank.rpt.
6. Navigate to an easy-to-access folder.
7. Click [Save].
8. Exit the program.

To create sample data for your report designs:

1. On the toolbar, click [Report Manager].
2. Click New Report > Crystal Report.
3. In the New Report window:

a. In the Reportbox, type a name for the report you want to create.

b. From the File Namebox, browse to and select an existing report design (.RPT) file.

C. If you want to change the order that information appears on the report:

i. For the Sequenceoption, select Custom.

ii. Click the browse button beside the option.

iii. In the left-hand pane of theEdit Grouping Hierarchy window that appears, select fields that represent the information you want appear on the report, clicking the right arrow key to include each one in the report sequence.

Use the up and down arrow keys to specify the order that this information will appear on the report:

d. Click [OK].

4. Select one or more estimates from the grid (lower right-hand pane) to use for sample data, and then click [Generate Data].

5. When prompted to select options for the report working data, click [OK] to accept the default selection.

Report Manager stores the sample data in a custom reports database, where it is available to use when you are designing reports.

6. Click [Check In].

[BCB:164:Chat Estimating US:ECB]

Learning about Report Manager (SQL)