Search
InstantDoc ID
GO

Browse By: Author | Issue

October 21, 2003 08:21 PM

A Deeper Look at Drillthrough

A closer look at a Microsoft example lets you create drillthrough for Excel
Rating: (0)
Russ Whitney
SQL Server Magazine
InstantDoc ID #40382
One of the most common reader questions I receive is, "How can I use the PivotTable and PivotChart components in Microsoft Excel?" These components, which enable simple analysis in Microsoft Excel or a custom application, work with either OLAP data sources or relational data sources. When you use it with an OLAP data source, the PivotTable component provides basic data-navigation (OLAP) capabilities. Because PivotTable's OLAP capabilities are available in Microsoft Office XP or Office 2000, whic...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

The download for InstantDoc #40382 didn't work. There was a VBA compile error in Excel when opening.

TC 2/4/2004 1:33:56 PM

very disappointed this article circumvented how
to utilize drillthrough with multiple dimensions
on page axis with multiple selections enabled.

P. Del 1/30/2004 3:39:51 PM

This code actually has a bug. When one filter(or page field) for the Pivot table has varios items selected the page field has the caption "Various items", in the inner loop where the page fields are checked, the property CurrentPageName for the object PageFields is empty and causes the code to fail.

Camilo Gutierrez 11/26/2003 7:20:56 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.