I want to jump from a pivotable list report to another one using an
hyperlink on a row member.
I didn't found any "before navigate" event launch by the pivottable list to
add the context (e.g selected members on filter axis) into the session.
Thus, I want to use the "Data Change" event (on reasons :
plDataReasonIncludedMembersChange, plDataReasonAllIncludeExcludeChange and
plDataReasonRemoveFieldSet) to store the actual context of my pivottable
into the session.
The Event works fine but I am unable to know which are the selected members
of the filter axis. Here is the code I use and the errors I have :
MsgBox "included array : " &
IsArray(Pivot.ActiveView.FilterAxis.FieldSets.Item(0).Fields.Item(0).Include
dMembers) => True, This is an array !
MsgBox
UBound(Pivot.ActiveView.FilterAxis.FieldSets.Item(0).Fields.Item(0).Included
Members) => 2. Fine !
Set oMember =
Pivot.ActiveView.FilterAxis.FieldSets(0).Fields(0).IncludedMembers(0) =>
Error: Object not a collection : 'IncludeMembers'...
I cannot understand why I have this error ! I use the result of
includedMembers as an array and I have an error mentionning a collection in
return !
Does somedy know what I am doing wrong ?
Do I have another mean to jump to another report keeping the context (at
least members in filter axis) ?
Thanks in advance,
Cédric.
I have to do a
For each member in
Pivot.ActiveView.FilterAxis.FieldSets.Item(0).Fields.Item(0).IncludedMembers
...
Next
and it works !
I still doesn't know why it doesn't work with an index...
Cédric.
"Cédric Pourcel" <c...@elca.ch> wrote in message
news:b76m1o$n0e$1...@dc2-03-su-03.t-systems.ch...