Chapter 16: Advanced Report Design


Overview

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.

Note 

image from book 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.




Microsoft Office Access 2007 Inside Out
MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
ISBN: 0735623252
EAN: 2147483647
Year: 2007
Pages: 234

Similar book on Amazon
Access 2007: The Missing Manual
Access 2007: The Missing Manual
Microsoftu00ae Office Access(TM) 2007 Step by Step (Step By Step (Microsoft))
Microsoftu00ae Office Access(TM) 2007 Step by Step (Step By Step (Microsoft))
Microsoft Office Access 2007 Forms, Reports, and Queries
Microsoft Office Access 2007 Forms, Reports, and Queries
Alison Balter's Mastering Microsoft Office Access 2007 Development
Alison Balter's Mastering Microsoft Office Access 2007 Development

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net