Adding a PivotChart to a Client Report

You can now design a form in PivotChart view to graphically display monthly revenue data. Note that a report doesn’t have a PivotChart or Pivot Table view, but it is perfectly legal to embed a form into a client report as a subreport.

Designing the PivotChart Form

When you built the subreport for the Facility Revenue report, you used a simple query on the tblReservations table. For the chart, you need to include the name of the facility—the ID won’t make much sense in the legend for the chart. In the sample database, you can find a query named qryXmplChtFacilityRevenue that includes both the tblFacilities and tblReservations tables. The fields in the query are FacilityID and FacilityName from the tblFacilities ...

Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.