Pivottable Filtering Bug crashes IE!!

[monte]

Hi there,

I need a solution to a serious problem, which i intend to
define as OWC-Bug:

I' m working with PivotTables (mainly OWC10) a lot and
recently developed searchfunctionality to search
dimensions for a special substring. A second IE window
pops up, where i can enter searchstring and select
Dimension to be searched.

I'v done this doing a search on the relational source,
which gives me back the keys of Dimension-Members, that
fit the searched criteria. After that i set that keys to
be filtered via this script:
===============================
opener.objPivotTable.ActiveView.Fieldsets
("Customer").Fields("Customer").IncludedMembers = Split("&
[123],&[1234],&[1456],&[241]", ",")
===============================

This worked perfectly in the first place, but whenever i
received a large amount of results (a lot of keys to be
filtered) I couldnt work (drilldown and so on)with the
filtered view no more or IE would crash.

So I added these lines to refresh and reset the filtered
view.
==============================
opener.objPivotTable.Refresh
tempvar = opener.objPivotTable.XMLData
opener.objPivotTable.XMLData = tempvar
opener.objPivotTable.Refresh
===============================

Now everything worked fine!

But as soon as i apply 3 or 4 searches in a row on the
same report without closing and reopening the browser,
the Browser crashes instantly with following Errormessage
(Eventlog)
===============================
Faulting Application IEXPLORE.EXE version 6.0.3790.0,
faulting module OWC10.dll, version 10.0.2621.0, fault
address 0x002ef415
===============================

Looks like a buffer-overflow to me but can an OWC -
Developer name the cause or even a solution for this
problem/bug or is anybody else having this problem?

Greetings Monte

 

[Monte]

I finally found a solution for this problem:

It's absolutely necessary to flush the Filter via

=======================================================
opener.objPivotTable.ActiveView.Fieldsets
("Customer").Fields("Customer").IncludedMembers = Array()
=======================================================
Else this unhandled exeption occurs and this (maybe more
dangerous than it appears now) buffer-overflow happens.

This is by far not a convenient way to do, because i
formerly wanted to realize adaptive Filtering
(Kombination of multiple searchfilters on one dimension)
which is not possible in a stable way.

I would really appreciate if a OWC Core Developer could
give a brief statement on this issue, about
cause/fix/patchrelease-roadmap ... either in this
newsgroup or via email

Greetings Monte