ACC2000: PivotTable Loses Connection to Data After You Demote Section

MORE INFORMATION

If you have designed a data access page with a grouped section, and the section includes a PivotTable control, the PivotTable control will immediately lose its connection to its data source if you choose to demote the section.

Steps to Reproduce the Behavior

1. Open the sample database Northwind.mdb or the sample Access project NorthwindCS.adp.
2. In the Database windows, click Pages under Objects, and then click New. Click Design View, select the Orders table from the drop-down list, and then click OK.
3. If the field list is not displayed, click Field List on the View menu.
4. Drag OrderID field from the Orders table from the field list into the Section: Unbound section of the data access page.
5. Drag the CustomerID field from the same table into the Header: Orders section of the data access page.
6. With focus still on the CustomerID text box, click the Promote button on the toolbar.
7. Click the Header: Orders-CustomerID bar and on the Insert menu, click Office PivotTable.
8. With focus still on the PivotTable control, click Properties on the View menu. In the property sheet, click the Format tab, and then set the following two properties of the PivotTable control:

      Height: 3in
      Left: 3in
   					

9. If the diagonal hash marks do not appear around the PivotTable control, click the control until the hash marks appear.
10. Right-click the PivotTable control, and then click Property Toolbox.
11. Expand Data Source, and select Orders from the Data Member list.
12. Close the PivotTable Property Toolbox, and then drag the following fields from the Orders table onto the respective sections of the PivotTable:
    
    

    Field	Section
    ShipCountry	Drop Filter Fields Here
    EmployeeID	Drop Column Fields Here
    ShipName	Drop Row Fields Here
    Freight	Drop Totals or Detail Fields Here

13. Note that the PivotTable is properly bound without you having to switch to Page view. Right-click the CustomerID text box or the PivotTable control, and then click Demote. Note that the PivotTable control immediately displays: Unable to connect to data.