I have an ActiveX Pivottable control on my site, with an OLAP datasource. Its all working beautifully - except my next hurdle is creating a drillthrough option that mimics the drillthrough functionality of the Cube Browser in Analysis Services.
PivotTable.ActiveObject.Value = returns null even when cell is selected
I've tried other objects and collections such as PivotAggregates, PivotData, etc. etc. etc.
Can someone point me in the right direction for help here? Anyone ever done this?