Capture RowMember Drill Down value...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

<script language='javascript'
for=My_PivotTable
event=SelectionChange()>
var pt = document.getElementById('My_PivotTable');
var pd = pt.ActiveData;
var ra = pd.RowAxis;
if (pt.SelectionType == 'PivotRowMembers')
{alert(ra.RowMember.Axis.Label.Caption);}
</script>

Based on the code above, I have a PivotTable where there is only one
FieldSet in the RowAxis of the PivotData object. When I hover over a
cell in the Totals columns of the PivotTable, the ToolTips box displays
a number of facts about the hovered-over cell. Among those facts is
something labeled 'Row Member:'. This contains a string that show the
succession of drilling down that pertains to the row over which the
pointer is hovering.

I'd like to be able to capture this string and write it to a cookie to
be applied to the FilterAxis of another published PivotTable page. The
"alert" above yields "undefined." So far ra.RowMember is a valid
object. The Axis property also references a valid object, as does the
Label property.

I need the appropriate combination of objects and properties to capture
this. Once I have that combination, I'll replace the alert with code
to put the captured string in form that can be placed into the
IncludedMembers property on the other page.

Thanks!
Ray <><

.

Relevant Pages

  • Re: Length of longest contiguous digits exercise
    ... this contiguous block of 1s is remembered ... string must not appear at any other point in the string. ... this is undefined when there is no capture ... (which happens when there are no digits in the ...
    (comp.lang.javascript)
  • Re: Regex Capture problem
    ... "learned" my regex using a freeware utility that had slightly different ... was trying to capture instead of. ... I have used Regex utilities before, so I understand the concepts of text ... Function RESub(str As String, SrchFor As String, ReplWith As String) As String ...
    (microsoft.public.excel.programming)
  • Re: SQL - Capture Specific Text and Copy to New Column/row
    ... The script is: ... Please advise of how I may capture only the date/time data. ... wildcard characters as characters in the string. ... by the Option Compare setting of the module. ...
    (microsoft.public.access.modulesdaovba)
  • Re: match/scan does not return multiple matches
    ... clearly the a+ group must match twice to match the string from ^ to $ ... It is possible to use split instead but using a single match would be ... for each matching group only at most *one* capture is ... when the regular expression is compiled. ...
    (comp.lang.ruby)
  • Re: Fastest way to store ints and floats on disk
    ... million facts). ... In the next step I would like to build up a database that is ... but how can I interface that with Python? ... string, and long C structures directly to disk, at a given offset. ...
    (comp.lang.python)