Share this Page URL

Chapter 10. Presenting Data with Reports > Creating a Report with the Report Wi... - Pg. 336

Presenting Data with Reports 336 In this chapter, we'll describe how to create a report using the Report Wizard and how to work with reports in Design view. We won't create examples of all the different kinds of reports you can create in Access. We'll focus on creating a grouped report and on how to display related data in a report using multiple subreports. We'll also look at the Chart Wizard, and we'll explain some of the prop- erties that control how a report prints and displays data on the screen. At the end of this chapter, we'll provide examples of Microsoft Visual Basic event procedures that manage the formatting and behavior of reports. Creating a Report with the Report Wizard Access provides several ways to create a report, including wizards and the Report Design window, in which you use the toolbox, field list, and Properties dialog box to set up the fields and controls for a report. Often the most efficient way to create a report is to start with the Report Wizard, apply one of the standard layout and format options that come with Access, and then make any modifications to the report in Design view. In the first procedure in this chapter, we'll run the Report Wizard and create a report that summarizes campaign expense data. In the wizard, we first select the report's record source and the fields to include on the report. We then indicate the fields by which the report's data will be grouped and designate a sort order for the records included in the report. Create a report with the Report Wizard 1. 2. Open the file HelloWorld10.mdb, located in the Chap10 folder where you copied the sample files for this book. In the Database window, click Reports in the Objects list, and then double-click Create Report By Using Wizard.