M
MalcolmH
I want to be able to query the underlying data within a pivotcache
programmatically. My data source changes daily and I want to be query
the data held in the pivotcache snapshot from code.
The Recordset property looks promising but so far I haven't had any joy
getting anything to work.
As drill down is doing what I want to be able to do, are there
properties exposed that will allow me to do something similar?
I would prefer not to have to set pivottable filters and criteria if at
all possible to do the same.
Any advice folks?
programmatically. My data source changes daily and I want to be query
the data held in the pivotcache snapshot from code.
The Recordset property looks promising but so far I haven't had any joy
getting anything to work.
As drill down is doing what I want to be able to do, are there
properties exposed that will allow me to do something similar?
I would prefer not to have to set pivottable filters and criteria if at
all possible to do the same.
Any advice folks?