Setting XMLData does not set chart layout

N

Neale

Hi,

I was under the impression that the XMLData property of the pivottable was a
read/write property. I have a (Access 2003) form which uses the PivotChart
view. The Form_Load procedure contains code to set up the axis and labels -
this works fine and gives me a "default view" of my data.

Then I drag/drop fields into different chart areas, and then I click a Save
button and write the XMLData to a table. Close the form and re-load it
(default values loaded OK) and then try to apply the saved XMLData to re-load
the chart I was viewing previously.

The chart clears, but does not re-display with the saved settings. The code
I am using to assign the XMLData is;

Form_frmQueryViewer.PivotTable.XMLData = strLoadedXMLData

How can I load a saved "chart view/layout"

Thanks
 
B

Brian

Neale,

If you are still working on this, I thought I might share my findings on
loading XMLData into a OWC chart. I've found that in order to reload a
saved OWC chart that was linked to a pivottable, you'll also need the
xmldata from the pivottable in the state it was in when you made your
chart. Basically instead of just saving the chart xmldata you also need
to save the pivottable's xmldata, and reload them together.

You need to create a pivottable and load the saved pivottable xmldata
into it, then load the saved chartspace xmldata into your chartspace.
Once you have loaded the chartspace, set it's datasource property to the
pivottable you just loaded with xmldata. Then execute the chartspace's
refresh method. This should produce a new chart with the same
configuration as the chart you saved.

I know you're using Access 2003, but here's the source for a test
webpage I made when I was trying to get the same functionality for a
website. Maybe you'll find it helpful.

Brian H.

Use Instructions:
1. Paste the xmldata for a pivottable into the left text area
2. Click bind pt to bind the xmldata to the pivottable
3. Paste the xmldata for a chartspace into the right text area. The
chartspace should have been associated with the pivottable whose xml
you put in the left text area. Additionally, bot sets of xmldata
should have been captured at the same time so the pivottable is in the
state the chartspace is expecting. Otherwise you may get unexpected
chart results.
4. Click the bind cs button to bind the chartspace xmldata to the
chartspace on the page.

---- Source Code ---
<html>
<head>
<title>Untitled</title>
<script language="javascript">
function startPTBind() {
var xmldata = document.getElementById("ptxmldata").value;
var pt = document.getElementById("pt");
if (xmldata!="") {
pt.XMLData=xmldata;
}
}
function startCSBind() {
var csxmldata = document.getElementById("csxmldata").value;
var ptxmldata = document.getElementById("ptxmldata").value;
var cs = document.getElementById("cs");
var pt = document.getElementById("pt");
if (csxmldata!="" && ptxmldata!="") {
cs.XMLData=csxmldata;
cs.DataSource=pt;
cs.refresh();
}
}
</script>
</head>

<body>
<div id="owccontrol">
<table>
<tr>
<td>Pivottable XMLData</td>
<td>Chartspace XMLData</td>
</tr>
<tr>
<td><textarea cols=""
rows="" name="ptxmldata" id="ptxmldata"></textarea></td>
<td><textarea cols=""
rows="" name="csxmldata" id="csxmldata"></textarea></td>
</tr>
</table>
<input type="button" name="btn1" id="btn1"
value="bind pt" onClick="javascript:startPTBind()">
<input type="button" name="btn2" id="btn2"
value="bind cs" onClick="javascript:startCSBind()">
</div>
<div id="owccontainer">

<OBJECT id="pt"
style="WIDTH: 100%; HEIGHT: 350px; visibility:visible;display:block;"
classid="clsid:0002E552-0000-0000-C000-000000000046" VIEWASTEXT>
</OBJECT>
<OBJECT
id="cs"
style="VISIBILITY: visible; WIDTH: 100%;"
classid="CLSID:0002E556-0000-0000-C000-000000000046"
VIEWASTEXT>
</OBJECT>
</div>

</body>
</html>
 
I

Ivanchain

Brian is quite right. I meet this problem too. So I think it's not
very good idea to link your chart to the Ptable if you want to sav
it's XMLdata
 
S

shashank

what XML file format it expects ?

i am using following it dont work :(

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl">
<Ucode>
<book id="bk101">
<author>Gambardella, Matthew</author>
<title>XML Developer's Guide</title>
<genre>Computer</genre>
<price>44.95</price>
<publish_date>2000-10-01</publish_date>
<description>An in-depth look at creating applications
with XML.</description>
</book>
<book id="bk102">
<author>Ralls, Kim</author>
<title>Midnight Rain</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000-12-16</publish_date>
<description>A former architect battles corporate zombies,
an evil sorceress, and her own childhood to become queen
of the world.</description>
</book>
<book id="bk103">
<author>Corets, Eva</author>
<title>Maeve Ascendant</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000-11-17</publish_date>
<description>After the collapse of a nanotechnology
society in England, the young survivors lay the
foundation for a new society.</description>
</book>
<book id="bk104">
<author>Corets, Eva</author>
<title>Oberon's Legacy</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2001-03-10</publish_date>
<description>In post-apocalypse England, the mysterious
agent known only as Oberon helps to create a new life
for the inhabitants of London. Sequel to Maeve
Ascendant.</description>
</book>
<book id="bk105">
<author>Corets, Eva</author>
<title>The Sundered Grail</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2001-09-10</publish_date>
<description>The two daughters of Maeve, half-sisters,
battle one another for control of England. Sequel to
Oberon's Legacy.</description>
</book>
<book id="bk106">
<author>Randall, Cynthia</author>
<title>Lover Birds</title>
<genre>Romance</genre>
<price>4.95</price>
<publish_date>2000-09-02</publish_date>
<description>When Carla meets Paul at an ornithology
conference, tempers fly as feathers get ruffled.</description>
</book>
<book id="bk107">
<author>Thurman, Paula</author>
<title>Splish Splash</title>
<genre>Romance</genre>
<price>4.95</price>
<publish_date>2000-11-02</publish_date>
<description>A deep sea diver finds true love twenty
thousand leagues beneath the sea.</description>
</book>
<book id="bk108">
<author>Knorr, Stefan</author>
<title>Creepy Crawlies</title>
<genre>Horror</genre>
<price>4.95</price>
<publish_date>2000-12-06</publish_date>
<description>An anthology of horror stories about roaches,
centipedes, scorpions and other insects.</description>
</book>
<book id="bk109">
<author>Kress, Peter</author>
<title>Paradox Lost</title>
<genre>Science Fiction</genre>
<price>6.95</price>
<publish_date>2000-11-02</publish_date>
<description>After an inadvertant trip through a Heisenberg
Uncertainty Device, James Salway discovers the problems
of being quantum.</description>
</book>
<book id="bk110">
<author>O'Brien, Tim</author>
<title>Microsoft .NET: The Programming Bible</title>
<genre>Computer</genre>
<price>36.95</price>
<publish_date>2000-12-09</publish_date>
<description>Microsoft's .NET initiative is explored in
detail in this deep programmer's reference.</description>
</book>
<book id="bk111">
<author>O'Brien, Tim</author>
<title>MSXML3: A Comprehensive Guide</title>
<genre>Computer</genre>
<price>36.95</price>
<publish_date>2000-12-01</publish_date>
<description>The Microsoft MSXML3 parser is covered in
detail, with attention to XML DOM interfaces, XSLT processing,
SAX and more.</description>
</book>
<book id="bk112">
<author>Galos, Mike</author>
<title>Visual Studio 7: A Comprehensive Guide</title>
<genre>Computer</genre>
<price>49.95</price>
<publish_date>2001-04-16</publish_date>
<description>Microsoft Visual Studio 7 is explored in depth,
looking at how Visual Basic, Visual C++, C#, and ASP+ are
integrated into a comprehensive development
environment.</description>
</book>
</Ucode>
</xsl:stylesheet>

url:http://www.ureader.com/msg/1106178.aspx
 

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

XMLData property will not set... cannot restore chart layout from 0
a problem about chartSpace's XMLData 1
Saving/Loading OWC Chart data 1
Chartspace XMLData documentation? 3
Drop down list control value in vba 2
Save PivotTable metaData as XML 0
CAN'T REALLY hide OWC's pivotTable's fieldlist box. 3
Persisted XML data error with chart: For MS MVPs 1

Top