XMLData and ChartSpace

[Chris Jones]

Dear Folks:

I'm trying to save a PivotChart for reloading later. I'm
trying to use the XMLData property of the ChartSpace
object. I've tried a bunch of things to get this to work,
but whatever I try doesn't work. The symptom is a "broken
connection" icon in the Field list dialog.

Here's the simplest sample code that illustrates the
problem.

'Get a reference to the chartspace object
set chsp = document.all("chsp")
'Extract the xmldata
xmlData1 = chsp.XMLData
'Now set it back
chsp.XMLData = xmlData1

The code is run after a PivotChart has been populated
with data from a database. It extracts the XMLData value
and then sets it back into the PivotChart. After it runs,
no chart is displayed, and the FieldList shows the
dreaded "missing connection" icon.

I've tried various insertions of chsp.Clear,
chsp.Refresh, but to no avail...

Thanks for your help.

Here's the XMLData in the ChartSpace object...

<xml xmlns:x="urn:schemas-microsoft-comffice:excel">
<x:ChartSpace> <x:OWCVersion>10.0.0.4109
</x:OWCVersion> <x:Width>23892</x:Width>
<x:Height>13626</x:Height> <x:AllowPropertyBrowser/>
<xataSource> <x:Type>InternalPivotList</x:Type>
<xivotListXML>&lt;xml xmlns:x=&quot;urn:schemas-
microsoft-comffice:excel&quot;&gt;

&lt;xivotTable&gt;

&lt;x:OWCVersion&gt;10.0.0.4109
&lt;/x:OWCVersion&gt;

&lt;xisplayScreenTips/&gt;

&lt;x:CubeProvider&gt;msolap.2&lt;/x:CubeProvider&gt;

&lt;xisplayFieldList/&gt;

&lt;x:FieldListTop&gt;376&lt;/x:FieldListTop&gt;


&lt;x:FieldListLeft&gt;1012&lt;/x:FieldListLeft&gt;
&#
10;
&lt;x:FieldListBottom&gt;747&lt;/x:FieldListBottom&gt;&#13
;

&lt;x:FieldListRight&gt;1212&lt;/x:FieldListRight&gt;

&lt;x:CacheDetails/&gt;

&lt;xataMember&gt;V_IMAT_INVENTORY_PROJECTION&lt;/xata
Member&gt;
&lt;x:Name&gt;Microsoft Office
PivotTable 10.0&lt;/x:Name&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;COLLECTION_INSTANCE&lt;/x:Name&gt;


&lt;xataType&gt;Integer&lt;/xataType&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareO
rderedMembersBy&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;START_DATE&lt;/x:Name&gt;

&lt;xataType&gt;Date&lt;/xataType&gt;

&lt;x:EncodedType&gt;adDBTimeStamp&lt;/x:EncodedType&gt;&#
13;

&lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareO
rderedMembersBy&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;INVENTORY_PROJECTION_ID&lt;/x:Name&gt;
&
#10;
&lt;xataType&gt;Integer&lt;/xataType&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareO
rderedMembersBy&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;MATERIAL_CODE&lt;/x:Name&gt;

&lt;x:EncodedType&gt;adChar&lt;/x:EncodedType&gt;
&#10
;
&lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareO
rderedMembersBy&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;PLANT_CODE&lt;/x:Name&gt;

&lt;x:EncodedType&gt;adChar&lt;/x:EncodedType&gt;
&#10
;
&lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareO
rderedMembersBy&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;REQTYPE&lt;/x:Name&gt;

&lt;x:EncodedType&gt;adVarChar&lt;/x:EncodedType&gt;
&
#10;
&lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareO
rderedMembersBy&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;QUANTITY&lt;/x:Name&gt;

&lt;xataType&gt;Number&lt;/xataType&gt;

&lt;xLDataOrientation/&gt;

&lt;x:EncodedType&gt;adDouble&lt;/x:EncodedType&gt;
&#
10;
&lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareO
rderedMembersBy&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;

&lt;x:Name&gt;Data&lt;/x:Name&gt;

&lt;x:Orientation&gt;Column&lt;/x:Orientation&gt;
&#10
; &lt;xosition&gt;-1&lt;/xosition&gt;

&lt;xataField/&gt;

&lt;/xivotField&gt;

&lt;xivotField&gt;
&lt;x:Name&gt;Sum of
QUANTITY&lt;/x:Name&gt;

&lt;xLName&gt;Total1&lt;/xLName&gt;

&lt;x:TotalNumber&gt;0&lt;/x:TotalNumber&gt;

&lt;x:Orientation&gt;Data&lt;/x:Orientation&gt;

&lt;xosition&gt;1&lt;/xosition&gt;

&lt;xarentField&gt;QUANTITY&lt;/xarentField&gt;
&#
10; &lt;/xivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;START_DATE By
Week&lt;/x:Name&gt;

&lt;x:SourceName&gt;START_DATE&lt;/x:SourceName&gt;
&#
10; &lt;x:BoundField/&gt;

&lt;x:AutoDateType&gt;ByWeek&lt;/x:AutoDateType&gt;
&#
10;
&lt;xataType&gt;Date&lt;/xataType&gt;

&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;START_DATE1&lt;/x:Name&gt;

&lt;x:SourceName&gt;START_DATE&lt;/x:SourceName&gt;
&#
10;
&lt;xataType&gt;Date&lt;/xataType&gt;

&lt;xarentField&gt;Years&lt;/xarentField&gt;


&lt;x:GroupType&gt;Seconds&lt;/x:GroupType&gt;


&lt;xLCaption&gt;Seconds&lt;/xLCaption&gt;

&lt;x:FilterCaption&gt;START_DATE By
Week&lt;/x:FilterCaption&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;ss&lt;/x:NumberFormat&gt;


&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Minutes&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE1&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Minutes&lt;/x:GroupType&gt;


&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;mm:&lt;/x:NumberFormat&gt;


&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Hours&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE1&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Hours&lt;/x:GroupType&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;hh&lt;/x:NumberFormat&gt;


&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Days&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE1&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Days&lt;/x:GroupType&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;dddd&lt;/x:NumberFormat&gt;
&#10
;
&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Months&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE1&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Months&lt;/x:GroupType&gt;

&lt;xLGroupType&gt;Weeks&lt;/xLGroupType&gt;


&lt;xLCaption&gt;Weeks&lt;/xLCaption&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Years&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE1&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Years&lt;/x:GroupType&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;yyyy&lt;/x:NumberFormat&gt;
&#10
;
&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;START_DATE By
Month&lt;/x:Name&gt;

&lt;x:SourceName&gt;START_DATE&lt;/x:SourceName&gt;
&#
10; &lt;x:BoundField/&gt;

&lt;x:AutoDateType&gt;ByMonth&lt;/x:AutoDateType&gt;
&
#10;
&lt;xataType&gt;Date&lt;/xataType&gt;

&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;START_DATE2&lt;/x:Name&gt;

&lt;x:SourceName&gt;START_DATE&lt;/x:SourceName&gt;
&#
10;
&lt;xataType&gt;Date&lt;/xataType&gt;

&lt;xarentField&gt;Years1&lt;/xarentField&gt;
&#10
;
&lt;x:GroupType&gt;Seconds&lt;/x:GroupType&gt;


&lt;xLCaption&gt;Seconds&lt;/xLCaption&gt;

&lt;x:FilterCaption&gt;START_DATE By
Month&lt;/x:FilterCaption&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;ss&lt;/x:NumberFormat&gt;


&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Minutes1&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE2&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Minutes&lt;/x:GroupType&gt;


&lt;xLCaption&gt;Minutes&lt;/xLCaption&gt;


&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;mm:&lt;/x:NumberFormat&gt;


&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Hours1&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE2&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Hours&lt;/x:GroupType&gt;

&lt;xLCaption&gt;Hours&lt;/xLCaption&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;hh&lt;/x:NumberFormat&gt;


&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Days1&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE2&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Days&lt;/x:GroupType&gt;

&lt;xLCaption&gt;Days&lt;/xLCaption&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10; &lt;x:NumberFormat&gt;dd-
mmm&lt;/x:NumberFormat&gt;

&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Months1&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE2&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Months&lt;/x:GroupType&gt;

&lt;xLCaption&gt;Months&lt;/xLCaption&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;mmm&lt;/x:NumberFormat&gt;


&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Quarters&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE2&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Quarters&lt;/x:GroupType&gt;


&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;&amp;quot;Qtr&amp;quot;#&lt;/x:Numbe
rFormat&gt;

&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xLPivotField&gt;

&lt;x:Name&gt;Years1&lt;/x:Name&gt;

&lt;x:BaseField&gt;START_DATE2&lt;/x:BaseField&gt;
&#1
0;
&lt;x:GroupType&gt;Years&lt;/x:GroupType&gt;

&lt;xLCaption&gt;Years&lt;/xLCaption&gt;

&lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
&
#10;
&lt;x:NumberFormat&gt;yyyy&lt;/x:NumberFormat&gt;
&#10
;
&lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrdered
MembersBy&gt;

&lt;/xLPivotField&gt;

&lt;xivotData&gt;

&lt;x:Top&gt;0&lt;/x:Top&gt;

&lt;x:TopOffset&gt;0&lt;/x:TopOffset&gt;

&lt;x:Left&gt;0&lt;/x:Left&gt;

&lt;x:LeftOffset&gt;0&lt;/x:LeftOffset&gt;

&lt;x:SeqNum&gt;3&lt;/x:SeqNum&gt;

&lt;/xivotData&gt;

&lt;xivotView&gt;

&lt;x:IsNotFiltered/&gt;

&lt;/xivotView&gt;

&lt;/xivotTable&gt;
&lt;/xml&gt;</xivotListXM
L> </xataSource> <x:BoundSeries>
<xataSourceIndex>0</xataSourceIndex>
</x:BoundSeries> <x:Category>
<xataSourceIndex>0</xataSourceIndex> </x:Category>
<x:Value> <xataSourceIndex>0</xataSourceIndex>
<xata>Total1</xata> </x:Value> <x:BoundCharts>
<xataSourceIndex>0</xataSourceIndex>
</x:BoundCharts> <x:FormatValue> <xataSourceIndex>-
3</xataSourceIndex> <xata>2</xata>
</x:FormatValue>
<xivotAggOrientation>None</xivotAggOrientation>
<xisplayFieldList/> <xalette>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry>
<x:Entry>#8080FF</x:Entry> <x:Entry>#802060</x:Entry>
<x:Entry>#FFFFA0</x:Entry> <x:Entry>#A0E0E0</x:Entry>
<x:Entry>#600080</x:Entry> <x:Entry>#FF8080</x:Entry>
<x:Entry>#008080</x:Entry> <x:Entry>#C0C0FF</x:Entry>
<x:Entry>#000080</x:Entry> <x:Entry>#FF00FF</x:Entry>
<x:Entry>#80FFFF</x:Entry> <x:Entry>#0080FF</x:Entry>
<x:Entry>#FF8080</x:Entry> <x:Entry>#C0FF80</x:Entry>
<x:Entry>#FFC0FF</x:Entry> <x:Entry>#FF80FF</x:Entry>
</xalette> <xefaultFont>Arial</xefaultFont>
<x:Chart> <xlotArea> <x:Graph>
<x:SubType>Clustered</x:SubType>
<x:Type>Column</x:Type> <x:Series>
<x:FormatMap> </x:FormatMap>
<x:Name>Series</x:Name> <x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>&quot;Series&quot;</xata>
</x:Caption> <x:Index>0</x:Index>
<x:Category>
<xataSourceIndex>0</xataSourceIndex>
</x:Category> <x:Value>
<xataSourceIndex>0</xataSourceIndex>
<xata>Total1</xata> </x:Value>
<x:FormatValue> <xataSourceIndex>-
3</xataSourceIndex> <xata>2</xata>
</x:FormatValue> <x:Marker>
<x:Symbol>None</x:Symbol> </x:Marker>
<x:Explode>0</x:Explode>
<x:Thickness>10</x:Thickness>
<xataSourceIndex>0</xataSourceIndex>
<x:Identifier>!</x:Identifier> </x:Series>
<ximension> <x:ScaleID>59335896</x:ScaleID>
<x:Index>Categories</x:Index> </ximension>
<ximension> <x:ScaleID>59336100</x:ScaleID>
<x:Index>Value</x:Index> </ximension>
<ximension> <x:ScaleID>59335692</x:ScaleID>
<x:Index>FormatValue</x:Index> </ximension>
<x:Overlap>0</x:Overlap>
<x:GapWidth>150</x:GapWidth>
<x:FirstSliceAngle>0</x:FirstSliceAngle> </x:Graph>
<x:Axis> <x:AxisID>59336304</x:AxisID>
<x:ScaleID>59335896</x:ScaleID>
<x:Type>Category</x:Type>
<x:MajorTick>Outside</x:MajorTick>
<x:MinorTick>None</x:MinorTick>
<xlacement>Bottom</xlacement>
<x:GroupingEnum>Auto</x:GroupingEnum> </x:Axis>
<x:Axis> <x:AxisID>59336912</x:AxisID>
<x:ScaleID>59336100</x:ScaleID>
<x:Type>Value</x:Type> <x:Number>
<x:FormatString>General</x:FormatString>
</x:Number> <x:MajorGridlines>
</x:MajorGridlines>
<x:MajorTick>Outside</x:MajorTick>
<x:MinorTick>None</x:MinorTick>
<xlacement>Left</xlacement> </x:Axis>
</xlotArea> <x:Identifier></x:Identifier>
</x:Chart> <x:Scaling>
<x:ScaleID>59335896</x:ScaleID> </x:Scaling>
<x:Scaling> <x:ScaleID>59336100</x:ScaleID>
</x:Scaling> <x:Scaling>
<x:ScaleID>59335692</x:ScaleID> </x:Scaling>
<xisplayToolbar/> </x:ChartSpace></xml>

 

[Dan Ricker]

I noticed that the XML for the internal PivotTable did not
contain a ConnectionString element.

Are you using an Extern OWC DataSourceControl? If so, you
need to use the Chart ConnectionString and DataMember
property instead for this to work.

-----Original Message-----
Dear Folks:

I'm trying to save a PivotChart for reloading later. I'm
trying to use the XMLData property of the ChartSpace
object. I've tried a bunch of things to get this to work,
but whatever I try doesn't work. The symptom is a "broken
connection" icon in the Field list dialog.

Here's the simplest sample code that illustrates the
problem.

'Get a reference to the chartspace object
set chsp = document.all("chsp")
'Extract the xmldata
xmlData1 = chsp.XMLData
'Now set it back
chsp.XMLData = xmlData1

The code is run after a PivotChart has been populated
with data from a database. It extracts the XMLData value
and then sets it back into the PivotChart. After it runs,
no chart is displayed, and the FieldList shows the
dreaded "missing connection" icon.

I've tried various insertions of chsp.Clear,
chsp.Refresh, but to no avail...

Thanks for your help.

Here's the XMLData in the ChartSpace object...

<xml xmlns:x="urn:schemas-microsoft-comffice:excel">
<x:ChartSpace> <x:OWCVersion>10.0.0.4109
</x:OWCVersion> <x:Width>23892</x:Width>
<x:Height>13626</x:Height> <x:AllowPropertyBrowser/>
<xataSource> <x:Type>InternalPivotList</x:Type>
<xivotListXML><xml xmlns:x="urn:schemas-
microsoft-comffice:excel">

<xivotTable>

<x:OWCVersion>10.0.0.4109
</x:OWCVersion>

<xisplayScreenTips/>

<x:CubeProvider>msolap.2</x:CubeProvider>


&#
10;
<x:FieldListBottom>747</x:FieldListBottom>
;

<x:FieldListRight>1212</x:FieldListRight>

<xataMember>V_IMAT_INVENTORY_PROJECTION</xata
Member>

PivotTable 10.0</x:Name>

<xivotField>

<x:Name>COLLECTION_INSTANCE</x:Name>

<xataType>Integer</xataType>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:CompareOrderedMembersBy>UniqueName</x:CompareO
rderedMembersBy>

</xivotField>

<xivotField>

<x:Name>START_DATE</x:Name>

<xataType>Date</xataType>

<x:EncodedType>adDBTimeStamp</x:EncodedType>&#
13;

<x:CompareOrderedMembersBy>UniqueName</x:CompareO
rderedMembersBy>

</xivotField>

<xivotField>

<x:Name>INVENTORY_PROJECTION_ID</x:Name> &
#10;
<xataType>Integer</xataType>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:CompareOrderedMembersBy>UniqueName</x:CompareO
rderedMembersBy>

</xivotField>

<xivotField>

<x:Name>MATERIAL_CODE</x:Name>

<x:EncodedType>adChar</x:EncodedType>

;
<x:CompareOrderedMembersBy>UniqueName</x:CompareO
rderedMembersBy>

</xivotField>

<xivotField>

<x:Name>PLANT_CODE</x:Name>

<x:EncodedType>adChar</x:EncodedType>

;
<x:CompareOrderedMembersBy>UniqueName</x:CompareO
rderedMembersBy>

</xivotField>

<xivotField>

<x:Name>REQTYPE</x:Name>

<x:EncodedType>adVarChar</x:EncodedType> &
#10;
<x:CompareOrderedMembersBy>UniqueName</x:CompareO
rderedMembersBy>

</xivotField>

<xivotField>

<x:Name>QUANTITY</x:Name>

<xataType>Number</xataType>

<xLDataOrientation/>

<x:EncodedType>adDouble</x:EncodedType> &#
10;
<x:CompareOrderedMembersBy>UniqueName</x:CompareO
rderedMembersBy>

</xivotField>

<xivotField>

<x:Name>Data</x:Name>

<x:Orientation>Column</x:Orientation>

; <xosition>-1</xosition>

<xataField/>

</xivotField>

<xivotField>

QUANTITY</x:Name>

<xLName>Total1</xLName>

<x:TotalNumber>0</x:TotalNumber>

<x:Orientation>Data</x:Orientation>

<xosition>1</xosition>

<xarentField>QUANTITY</xarentField> &#
10; </xivotField>

<xLPivotField>

<x:Name>START_DATE By
Week</x:Name>

<x:SourceName>START_DATE</x:SourceName> &#
10; <x:BoundField/>

<x:AutoDateType>ByWeek</x:AutoDateType> &#
10;
<xataType>Date</xataType>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>START_DATE1</x:Name>

<x:SourceName>START_DATE</x:SourceName> &#
10;
<xataType>Date</xataType>

<xarentField>Years</xarentField>

<x:GroupType>Seconds</x:GroupType>

<xLCaption>Seconds</xLCaption>

<x:FilterCaption>START_DATE By
Week</x:FilterCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>ss</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Minutes</x:Name>

<x:BaseField>START_DATE1</x:BaseField>

0;
<x:GroupType>Minutes</x:GroupType>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>mm:</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Hours</x:Name>

<x:BaseField>START_DATE1</x:BaseField>

0;
<x:GroupType>Hours</x:GroupType>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>hh</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Days</x:Name>

<x:BaseField>START_DATE1</x:BaseField>

0;
<x:GroupType>Days</x:GroupType>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>dddd</x:NumberFormat>

;
<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Months</x:Name>

<x:BaseField>START_DATE1</x:BaseField>

0;
<x:GroupType>Months</x:GroupType>

<xLGroupType>Weeks</xLGroupType>

<xLCaption>Weeks</xLCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Years</x:Name>

<x:BaseField>START_DATE1</x:BaseField>

0;
<x:GroupType>Years</x:GroupType>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>yyyy</x:NumberFormat>

;
<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>START_DATE By
Month</x:Name>

<x:SourceName>START_DATE</x:SourceName> &#
10; <x:BoundField/>

<x:AutoDateType>ByMonth</x:AutoDateType> &
#10;
<xataType>Date</xataType>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>START_DATE2</x:Name>

<x:SourceName>START_DATE</x:SourceName> &#
10;
<xataType>Date</xataType>

<xarentField>Years1</xarentField>

;
<x:GroupType>Seconds</x:GroupType>

<xLCaption>Seconds</xLCaption>

<x:FilterCaption>START_DATE By
Month</x:FilterCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>ss</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Minutes1</x:Name>

<x:BaseField>START_DATE2</x:BaseField>

0;
<x:GroupType>Minutes</x:GroupType>

<xLCaption>Minutes</xLCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>mm:</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Hours1</x:Name>

<x:BaseField>START_DATE2</x:BaseField>

0;
<x:GroupType>Hours</x:GroupType>

<xLCaption>Hours</xLCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>hh</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Days1</x:Name>

<x:BaseField>START_DATE2</x:BaseField>

0;
<x:GroupType>Days</x:GroupType>

<xLCaption>Days</xLCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10; <x:NumberFormat>dd-
mmm</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Months1</x:Name>

<x:BaseField>START_DATE2</x:BaseField>

0;
<x:GroupType>Months</x:GroupType>

<xLCaption>Months</xLCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>mmm</x:NumberFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Quarters</x:Name>

<x:BaseField>START_DATE2</x:BaseField>

0;
<x:GroupType>Quarters</x:GroupType>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>&quot;Qtr&quot;#</x:Numbe
rFormat>

<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xLPivotField>

<x:Name>Years1</x:Name>

<x:BaseField>START_DATE2</x:BaseField>

0;
<x:GroupType>Years</x:GroupType>

<xLCaption>Years</xLCaption>

<x:EncodedType>adInteger</x:EncodedType> &
#10;
<x:NumberFormat>yyyy</x:NumberFormat>

;
<x:CompareOrderedMembersBy>Name</x:CompareOrdered
MembersBy>

</xLPivotField>

<xivotData>

<x:Top>0</x:Top>

<x:TopOffset>0</x:TopOffset>

<x:Left>0</x:Left>

<x:LeftOffset>0</x:LeftOffset>

<x:SeqNum>3</x:SeqNum>

</xivotData>

<xivotView>

<x:IsNotFiltered/>

</xivotView>

 

[Chris Jones]

Thanks. This worked like a charm.

-----Original Message-----
I noticed that the XML for the internal PivotTable did not
contain a ConnectionString element.

Are you using an Extern OWC DataSourceControl? If so, you
need to use the Chart ConnectionString and DataMember
property instead for this to work.










.