I am using VBA code provided my microsoft for drillthrough in access. It
works fine as far as all and/or only one levels are selected in page fields.
I receive a runtime error when I do the following:-
1) Click on the pagefields and then select "Select multiple items"
2) Select 2 or more levels from that particular pagefield
3) Run the drillthrough script.

Is this possible? And if yes then please guide me...
Thanks in advance!

Fazal

Fazal,

You don't mention which version of AS you are using, but my guess would
be that you are using AS 2000, in which case this is not possible.

In AS 2000 the ability to filter on multiple members is implemented by
creating a calculated member on the fly, hence when you try to drill
through there is no "real" member which can be linked back to actual
fact table rows.

In AS 2005 this should be possible as it natively allows for filtering
by a set of members.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <06CDB012-BC07-4EBA-94CB-00D0C95FBBAE (AT) microsoft (DOT) com>,
Fazal (AT) discussions (DOT) microsoft.com says...