Hi folks,

I have a requirement to produce pivot tables for end-user consumption -
preferably via a webpage, but a dynamically generated Excel file would
also be suitable.

I'm thinking of using the Office Web Components that are associated
with MS Office - my experiments with the PivotTable so far seem mostly
positive (in as much as I can get data out of my DB, and have a PT
appear), but the control itself appears to have a few usability issues
(invisible horizontal scrollbars springs to mind) which is a shame
given that people are comfortable with it. I've not been using this
for long, so I probably doing something wrong :-)

So the question is, how do other people achieve this. As I see it
there are three main options;

(i) Use OWC as <OBJECT>s in a webpage and either populate the XMLData
property with appropriately formatted data, or program it directy from
Javascript (yuck)

(ii) Write out an entire spreadsheet manually in XML for importing back
into an end-users local Excel installation that contains the necessary
pivottable definitions

(iii) Go with a 3rd part toolkit to make (ii) more straightforward, or
a 3rd party ActiveX type component to replace (i)

This data will ultimately come from Oracle rather than SSAS and be
(probably) be relational rather than cubed if that has any influence.
I'm looking for a bit of a steer if anyone would care to comment.

Thanks for all and any suggestions.

Regards