In the previous chapter, you learned how to create a relatively simple report with a single subtotal level. You also saw how the Report Wizard can help you construct a new report. This chapter shows you how to
Design a report with multiple subtotal groups
Add complex calculations to a report
Embed a report within another report
Create a report with an embedded PivotChart form
To learn how to work with these features, you’ll create a Facility Occupancy By Date report for the Housing Reservations database. In a second example, you’ll learn how to use the results from two queries in an embedded subreport and an embedded PivotChart to produce a report that summarizes and graphs revenue by facility and month.
The examples in this chapter are based on the reports, queries, tables, and data in HousingDataCopy2.accdb on the companion CD included with this book. You can find similar reports in the Housing Reservations sample application, but all the reports in that sample file have custom Ribbons defined, so you won’t see the four main Ribbon tabs-Home, Create, External Data, and Database Tools-when you open those reports. The results you see from the samples in this chapter might not exactly match what you see in this book if you have changed the sample data in the files. Also, all the screen images in this chapter were taken on a Microsoft Windows Vista system with the display theme set to Blue. Your results might look different if you are using a different operating system or a different theme.