Report wizard (overview and use)
You can quickly create useful reports by using the Report wizard. You specify which table or query contains the data you want to display in the report, and the wizard links to it automatically. The rest of the wizard’s options let you do the following:
Display detail rows or just summary information.
Specify fields to be included in the report.
Group the report by specific fields. You can nest subgroups within groups.
Choose aggregate operations that can be applied both to a group and to the entire report.
Specify layout style, including a drill-down option, which displays summary information at the top of the page and details farther down.
Specify a report title.
Include the date.
Include page numbers, which causes the report to display one screenful at a time.
The Report wizard does so much that for many reports you won’t need to go any further. You can, however, add complex query statements to your reports by writing code or using the SQL designer to generate SQL statements. And you can add advanced reporting capabilities, as needed, in the Report designer.
It’s easiest to begin creating a report by using the Report wizard. You can then modify the design in the Report designer. By using code, you can add a great deal of analysis to your reports and provide more sophisticated and useful pictures of the data in one or more tables.
To use the Report wizard
Choose File|New|Report. Or, double-click the leftmost Untitled icon on the Reports page of the Navigator. The New Report dialog box appears.
Click the Wizard button.
For help on any wizard page, click the Help button on that page.