what i have discovered is that owc9 dont support recordsets while owc11
support recordsets

' owc9
objPivotTable.DataSource =objRS

'this give error : Class does not support Automation or does not support
expected interface


but above line of code works fine if owc11 is used. it means OWC11 capable
of accepting Recordsets as datasource whil owc9 is not.

so i think next version of owc can be made capable of accepeting Datasets as
well

"Alvin Bruney [ASP.NET MVP]" wrote:

The reason is that the DataSets do not implement IDataSource which is
required for binding to the Office Web Components. If you have the time and
energy, simple subclass the dataset to implement IDataSource yourself,
otherwise use one of the other methods available

--
Regards,
Alvin Bruney

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
------------------------------------------------------------

"Sarfraz Ahmed" <Sarfraz wrote in message
...
owc11 Pivot table should also be filled with DataSets.

I am developing an applciation which uses Pivot tables for anaylitical
View.
This applciation is being developed on .net platform. and SQLHelper class
[microsoft data access application block ] is being used for STANDARDIZED
data access.

this class provide datasets and datareaders mechanisms but NOT the
Recordset.
On the other hand Pivot table datasource can be set to Recordsets or XML
files. but NOT the datasets.

In order to fill pivot table i have to explicitly use Recordset
mechanism.[there for the standarized definition doesn't meet for this
case]

One solution is to convert the Dataset to recordset.
microsoft suggests this by using 3 steps

1) DataSet will be transformed to- an external XML File / xml stream
2)A recordset will be filled by that External XML File / xml stream
3) and then that record set may be used to set pivot table data source.

the problem here is since quries themselve are very time consuming
and by using above method it will take more time.

other solution is to have owc11 much intelligent to accept datasets as
their
Datasources.

Your feedback will highly be appreciated.
Kind Regards
Sarfraz Ahmed