• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Lesson 23. Creating a Simple Report > Creating a Report with the Report Wizard

Creating a Report with the Report Wizard

The Report Wizard offers a good compromise between ease-of-use and flexibility. With the Report Wizard, you can use multiple tables and queries and choose a layout and format for your report. Follow these steps to create a report with Report Wizard:

  1. Open the database containing the table or query on which you want to report.

  2. Click the Reports tab in the Database window.

  3. Double-click Create report by using wizard to start the Report Wizard (see Figure 23.2).

    Figure 23.2. The first Report Wizard dialog box.

  4. From the Tables/Queries drop-down list, select a table or query from which you want to include fields.

  5. Click a field in the Available Fields list, and then click the > button to move it to the Selected Fields list. Repeat this step to select all the fields you want, or click to move all the fields over at once.

  6. If desired, select another table or query from the Tables/Queries list and repeat step 5. The tables you choose should have relationships between them, so your data will match up on the report. When you finish selecting fields, click Next. The wizard's next dialog box appears (see Figure 23.3).

    Figure 23.3. Set your report's grouping.

  7. If you want the records grouped by any of the fields you selected, click the field, and then click the button. You can select several grouping levels in the order you want them. Then click Next to move on.


    Grouping? By default, there are no groups. You have to select a field and click the > button to create a group. Grouping sets off each group on the report. If you use a field to group, the Grouping Options button becomes active, and you can click it to specify precise grouping settings.

  8. You're asked what sort order you want to use (see Figure 23.4). If you want sorted records, open the top drop-down list and select a field to sort by. Select up to four sorts from the drop-down lists; then click Next.

    Figure 23.4. Set the sort order.


    Ascending or Descending? By default, the sort is in ascending order (A–Z). Click the AZ button next to the box to change the sort order to descending (Z–A) if you like.

  9. In the next dialog box (see Figure 23.5), choose a layout option from the Layout section. When you click an option button, the sample in the box changes to show your selection.

    Figure 23.5. Choose the layout of your report.


    Where Are All the Layouts? If you don't choose any groupings in your report, your layout choices are limited to three: Columnar, Tabular, and Justified. The layouts shown in Figure 23.5 are unique to grouped reports.

  10. Choose which orientation your printed report will have: Portrait (across the narrow edge of the paper) or Landscape (across the wide edge of the paper). Then click Next to continue.

  11. In the next wizard dialog box, you're asked to choose a report style. Several are listed; click one to see a sample of it, and then click Next when you're satisfied with your choice.

  12. You're asked for a report title. Enter one in the Report text box, and click Finish to see your report in Print Preview (see Figure 23.6).

    Figure 23.6. Here's a simple report with no grouping.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint