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

Chapter 6. Exploring Reports > Designing a Relational Report Using a Wizard

Designing a Relational Report Using a Wizard

Just as you designed a relational form using a wizard in the last chapter, you can use a wizard to design a report in much the same way. You can design the report from scratch or just base the report on a relational query, but for most purposes, you might as well take advantage of a Report Wizard. The following steps show you how to design a relational report using a report wizard:

1.
Be sure the Music Store database is open.

2.
Under Objects, click Reports to view a list of reports and report options.

3.
Click Create Report by Using Wizard to open the wizard.

4.
Under Tables/Queries, click the drop-down box, and then choose Table:Customers.

5.
Under Available Fields, click >> to move all the fields over to the Selected Fields box.

6.
Click the Sort Name field under Selected Fields and click < to bring it back to the Available Fields box.

7.
Stay in the dialog box. Under Tables/Queries click the down arrow and choose Table:Invoice.

8.
Under Available Fields click >> to move all the fields over to the Selected Fields box.

9.
Click Invoice.CustomerID under Selected Fields and click < to bring it back to the Available Fields box.

10.
Repeat steps 7 and 8 for Table:InvoiceDetail.

11.
Click the InvoiceDetail.InvoiceID field and click < to bring it back to the Available Fields box. Click Next.

12.
On page 2 of the wizard, which asks, “How do you want to view your data?” click Next to accept the selection “by Customers.”

13.
On page 3, which is the grouping levels page, click Next to accept the default grouping levels.

14.
On page 4, which is the sort order page, click Next to use no sorting in this report.

15.
On page 5, which is the layout page, choose Align Left 1 (leave the default of Portrait for Orientation as shown in Figure 6.23) and choose Next.

Figure 6.23. Choosing a layout for your report using a Report wizard.


16.
On the style screen, after cycling through the various styles, leave Corporate and choose Next.

17.
On the next screen, title the report Customer Invoices and click Finish.

18.
Click Close to look at the design screen. Close the report.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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