Save current view of OWC Pivottable (OLAP datasource)

  • I've been researching for weeks how to save a current view of a pivottable office web component (OWC) that relies on an OLAP data source.  Unfortunately, I can't find an explicit answer.

    I can construct a simple web page that contains the OWC Pivottable along with the connection string, so that I can easily create a default view of a pivottable. But, I don't know how to save off the pivottable 'XMLData' property where the actual xml data resides.  I can display the XMLData property in a popup window (kind of like a tooltip), but I just don't know how to literally save the info into an actual file.

    Does anyone have actual code that will save (and load) the XMLData property of an OWC Pittable to a file? (e.g., C:\temp\test1.xml).

    Note: suggestions such as "why don't you set xmldata property to a variable and then save the variable to a string in a sql table" aren't helpful. I'm looking for actual code -- I know my sql, but OWC and asp/vbscript/jscript is all foreign to me.

    Thanks!

     

     

  • Seems like the best place to find this is in the Office SDK (under samples or something).  I don't have it, though; and Microsoft is not known for making good examples available online.

    Personally, I use Google groups....

    cl

    Signature is NULL

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply