Create the New Report
Now that we have put a query in place to
act as a data source, we are ready to set about the report's creation, and its
subsequent binding to its source. We will take the following actions to
complete our objectives:
1.
In the Objects
pane on the left side of the Database window, click the Reports button, shown in Illustration
10.
Illustration 10: Select
Reports in the Object Pane of the Database Window
We arrive at the Reports
window, and see various sample reports that are already there.
2.
Click the New
button that appears in the toolbar, as depicted in Illustration 11.
Illustration 11: The
New Button in the Toolbar of the Reports Window
The New Report
dialog appears, with Design View selected by default.
3.
Ensuring that
Design View is selected, click the arrow on the selector for the Choose the
Table or Query where the Object's Data comes from box in the lower section
of the dialog.
4.
Select the Customer_Orders_Source
query we created in the last section.
The New
Report dialog appears as shown in Illustration 12.
Illustration 12: The
New Report Dialog, with Settings
After
a few seconds, perhaps less, we are greeted by the Report Design window,
which displays header, detail and footer sections. Also apparent is the Field
List from the Customer_Orders_Source query, which floats, as it
were, over the Report Design window, as depicted in Illustration 13.
Illustration 13: The
Report Design Window Dialog, with Source Field List
We can
see, by the contents of the Field List, that the blank report is bound
to the data source. We are now in a position to establish some of the physical
characteristics of the report.