Microsoft KB Archive/306756

= PRB: Unable to Display Visual Totals Using the PivotTable Component =

Article ID: 306756

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft Office Web Components
 * Microsoft Office Web Components
 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q306756



SYMPTOMS
When you use the PivotTable component and you choose the option to calculate totals based on visible items only, you may receive the following error message:

The data source does not support totalling only visible items.



CAUSE
The PivotTable component does not support visual totals when the computer connects to the data source by using version 1.0 of the OLE DB Provider for OLAP Services.



RESOLUTION
To resolve this problem, modify your connection string to use version 2.0 of the OLE DB Provider for OLAP Services. This resolution is illustrated in the &quot;More Information&quot; section.



Steps to Reproduce Behavior
  Start Notepad.exe and paste the following HTML in a new file:    id=&quot;PTable&quot; Width=&quot;200&quot; Height=&quot;200&quot;> 

 Function Window_OnLoad

PTable.AutoFit = False PTable.ConnectionString = _ &quot;provider=msolap.1;data source=YourServer;initial catalog=Foodmart 2000;&quot; PTable.DataMember = &quot;Sales&quot;

End Function

  Note Replace the  in the above code with the Class ID of the Pivot Table control being used.

For Microsoft Office PivotTable 10.0

0002E552-0000-0000-C000-000000000046  Change YourServer in the connection string to the name of your SQL server.</li> Save the file as Pivot.htm.</li> Start Microsoft Internet Explorer and browse to Pivot.htm.</li> After the Web page is rendered, click Commands and Options on the PivotTable toolbar. On the Report tab, select the option to calculate totals based on Visible Items Only. You receive the error that is described in the &quot;Symptoms&quot; section.</li></ol>

To correct this problem, modify the connection string in the code as follows so that it uses the msolap.2 provider: PTable.ConnectionString = _ &quot;provider=msolap.2;data source=YourServer;initial catalog=Foodmart 2000;&quot;

Additional query words: olap msolap pivot table pivotlist owc owc10

Keywords: kbprb kbofficewebpivot KB306756

-

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

© Microsoft Corporation. All rights reserved.