ACC2002: PivotTable or PivotChart View Is Missing When You Save a Form as a Report (310492)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q310492
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you save a form in PivotTable or in PivotChart view as a report, the report does not have a PivotTable or PivotChart object.

CAUSE

Unlike forms, reports do not have different views such as Datasheet view, PivotTable view, or PivotChart view. Only the appearance of the Design view of the form can be represented when you save a form as a report.

RESOLUTION

To view a PivotTable or PivotChart object in a Microsoft Access report, you must create a form and then customize the layout of its PivotTable or PivotChart view. Then you must set the DefaultView property of the form to PivotTable or PivotChart and embed the form as a subform on a report. For an example of how to do so, follow these steps:
  1. Open the sample database, Northwind.mdb.
  2. Create a new, blank form that is based on the Orders table.
  3. If the field list is not visible, click Field List on the View menu.
  4. Drag the EmployeeID, ShipVia, and Freight fields from the field list to the form.
  5. Set the DefaultView property of the form to PivotChart.
  6. On the File menu, click Save. When you are prompted, save the form as frmSubPivotChart.
  7. On the View menu, click PivotChart View.
  8. Drag the EmployeeID field from the PivotChart field list to the Drop Category Fields Here area.
  9. Drag the ShipVia field from the PivotChart field list to the Drop Series Fields Here area.
  10. Drag the Freight field from the PivotChart field list to the Drop Data Fields Here area.
  11. Close the form.
  12. Create a new, blank report, and then open it in Design view.
  13. Position the report in such a way that you can see the Database window, and then drag the frmSubPivotChart form from the Database window to the detail section of the report.
  14. On the File menu, click Print Preview.

    Note that the report displays the PivotChart object that you created in the form.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Forms under Objects, click the Sales Analysis Subform2 form, and then click Open. Note that the form opens in PivotChart view.
  3. On the File menu, click Save As.
  4. In the Save As dialog box, click Report in the As box, and then click OK.
  5. Close the form.
  6. In the Database windows, click Reports under Objects, click the Sales Analysis Subform2 report, and then click Preview.

    Note that the report does not display a PivotChart object. Rather, it displays the appearance of the Sales Analysis Subform2 form in Design view.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbnofix kbprb KB310492
©2003 Microsoft Corporation. All rights reserved.