Microsoft® Access® 2010 Inside Out

Chapter 18. Advanced Report Design

• Building a Query for a Complex Report

• Creating the Basic Facility Occupancy By Date Report

• Defining the Grouping and Sorting Criteria

• Setting Section and Report Properties

• Using Calculated Values

• Creating and Embedding a Subreport

• Adding a PivotChart to a Client Report

In Chapter 17, you learned how to create a relatively simple client report with a single subtotal level. You also saw how the Report Wizard can help you construct a new client report. This chapter shows you how to do the following:

• Design a client report with multiple subtotal groups

• Add complex calculations to a client report

• Embed a report within another client report

• Create a client report with an embedded PivotChart form

To learn how to work with these ...