Robin

As far as DAO, ADO or any other type of data access, or recordset is
concerned, there is no better expert than Rob Bovey. I would stake that if
he say's it can't be done...it really can't.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Robin Hammond" wrote in message
...
Has anyone found a way to get a pivottable to work with a filtered
recordset?

The intent is fairly simple. Filter a complex RS, pass a column, row, and
data parameter to a generic output routine, and use a pivottable to do the
output to a worksheet. It seems that although the recordset is filtered,
the
pivottable ignores the filtering and includes all items.

I'm sure I can get around it by adding an additional column and filtering
the column, pastevalues, delete the column, etc, but would rather the damn
thing behaved as it should.

Correct:
rsWhatever.Filter = "something"
Set pcOutput.Recordset = rsWhatever

Incorrect:
probably about 50 lines of nasty code adding additional columnfield and
filtering the pivottable.
Sometimes you have to question who's thinking these things up.

There's a thread with a response from Rob Bovey here saying that it can't
be
done directly, but I'd welcome other suggestions.


http://www.google.com.hk/groups?hl=e...r%3D%26hl%3Den

Robin Hammond
www.enhanceddatasystems.com