Microsoft KB Archive/905165

= Incorrect results appear when you drill into a filtered Office Web Component PivotChart on a Web page =

Article ID: 905165

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Office Professional Edition 2003
 * Microsoft Office Standard Edition 2003
 * Microsoft Office Student and Teacher Edition 2003
 * Microsoft Office Small Business Edition 2003
 * Microsoft Office Basic Edition 2003
 * Microsoft Office XP Professional Edition
 * Microsoft Office XP Small Business Edition
 * Microsoft Office XP Standard Edition
 * Microsoft Office XP Standard Edition for Students and Teachers
 * Microsoft Office XP Developer Edition
 * Microsoft Office 2000 Professional Edition
 * Microsoft Office 2000 Standard Edition
 * Microsoft Office 2000 Small Business Edition
 * Microsoft Office 2000 Developer Edition

-



SYMPTOMS
When you drill into a Microsoft Office Web Components (OWC) PivotChart on a Web page that was created in one of the programs that are listed in the &quot;Applies to&quot; section, the PivotChart results may not appear as expected.

For example, assume a situation where you filter (slice) the data that is in an OWC PivotChart. Then, you double-click (drill into) the data points. In this situation, the Web component displays the details of the data.

However, if you then double-click the data point to see additional details, the first filter is removed. Then, additional data points are added to the PivotChart.



CAUSE
This behavior may occur when all the following conditions are true:
 * Data that is stored in an Online Analytical Processing (OLAP) database or in a cube file was used to create the PivotChart report.
 * The OWC PivotTable already contains a filter (slice).
 * You drill into the filtered results of the OWC PivotChart.

After you drill into the filtered OWC PivotChart, the filter is removed and the filtered data retrieves information from all the rows of your database.



WORKAROUND
This behavior is by design. To work around this behavior, link the PivotChart to a PivotTable. Then, use the PivotTable to control the PivotChart.

Additional query words: office2003 office2k3 off2003 off2k3 office2002 office2k2 officexp off2002 off2k2 offxp office2000 office2k off2000 off2k drill into row

Keywords: kbofficewebpivot kbtshoot kbprb KB905165

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.