How to save Chart bound to PivotTable

R

Rabbani

Hi

I am able to save a pivottable report by saving the PivotTable.XMLData. While displaying back this Saved Report, I am assigning this XMLData to the PivotTable as PivotTable.XMLData = XMLData.

Now that our users want to save the Chart (which is bound to the pivottable on the same asp page) as well along with the pivot table. The users want to save the complete report (both PivotTable and Chart), they also want to make some changes in the chart like changing the chart type, changing colors, background etc.

The problem is that when I am saving the ChartSpace.XMLData along with PivotTable.XMLData, but when I set them back, the PivotTable shows up well but the ChartSpace is empty.

I will really appreciate if you can help me with this

Thanks
Rabban
 
T

Thao Moua [ms]

When you restored the controls' XMLData properties, make sure you restore the Pivotlist control first and then the Chartspace. If the Chartspace XMLData is restored first, it assumed the datasource (Pivotlist in this case) already have the data

Thao Mou
OWC Webchart Suppor

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to synchronize pivotTable and pivotChart? 0
#N/A values when exporting PivotTable to Excel 0
OWC11 PivotTable - possible work in background ? 1
Save PivotTable metaData as XML 0
How to create a bubble chart with more than 2 variables. 0
How to get OWC PivotTable data into an Excel Application 1
Saving/Loading OWC Chart data 1
Issue with binding data to the Pivot Table control in OWC 0

Top