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

The OWC.PIVOTTABLE object has the ActiveConnection property (for connecting
to a data source) and a CommandText property (for selecting data from that
source): then use the ActiveView.FieldSets object to build the pivot table.

"Sarfraz Ahmed" wrote:

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

I know we can use the ActiveConnection and CommandText properties to fill
the pivot table but u see this pivot table Control will deal with connection
and commands at its own in this case. The concern here is to implement the
Standardized Data Access to make application run Faster and more reliable. In
order to implement this we must use a single Data Access bridge (i.e
SQLHelper ) to Access Data. nothing else like letting the control itself
access the data or using any other mechanism.

i hope u have now got my point...:)
"AA2e72E" wrote:

The OWC.PIVOTTABLE object has the ActiveConnection property (for connecting
to a data source) and a CommandText property (for selecting data from that
source): then use the ActiveView.FieldSets object to build the pivot table.

"Sarfraz Ahmed" wrote:

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

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

Thanks Mr. Alvin for your Precise reply..i am saving my energy and using the
the simple recordset ..:).

"Sarfraz Ahmed" wrote:

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

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