OWC pivot table only displaying string values

[Brian Hman]

Hi,

I'm using an OWC pivot table to grab data from an ASP.NET application. I'm
using XSL to convert the ADO.NET recordset to ADO just like the examples
shown in kb articles 303016 and 316337. Even though the schema in the ADO xml
indicates that various columns should be string, double, etc it still only
displays the data in the pivot table as strings.

Does anyone know how to format the data properly?
Or could you guide me to an example that does this?

Thanks,
Brian

 

[Wei-Dong XU [MSFT]]

Hi Brian,

I'd suggest you can try one property UseProviderFormatting (undocumented
and un-supported) for this issue. This article will introduce more
information for you.
Five Tips for the Microsoft Office XP Web Components (April 2003)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnowc/html/
odc_owctips.asp

If this issue remains, could you be so kind to build one sample so that I
can perform further research for you. My mail box is:
(e-mail address removed)(please remove the online. which is to avoid the
spam)

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong XU (WD.XU)
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wei-Dong XU [MSFT]]

Hi Brian,

Thanks for the sample files!

After reading them and with one research, I find that the Chart Component
can bind to a data source that implements the
IDataSource interface, a standard COM interface for data source controls.
The other Office XP/2003 Web Components (that is, the PivotTable Component,
the Spreadsheet Component, and the DataSource controls) implement
IDataSource, and may be potential data sources for a chart.

However, the DataSet class in ADO.NET does not implement IDatasource, and
the .NET Framework does not support a direct means to convert an ADO.NET
DataSet object to an ADO Recordset object. So if you have a DataSet from
which you want to create a chart, you can use one of the two solutions that
are presented in the kb article 303016.
1. transform the DataSet into a stream that uses the XML persistence format
for ADO
or
2. generate literal data from the DataSet.

So xslt is very important for passing the data from ADO.net to ADO for the
usage of Pivottable and Pivot Chart. One 3rd party sample on converting the
ADO.net to ADO will provide some assistance for you (with the source
sample):
Transform an ADO.NET DataSet to ADO Recordset XML, Excel XML and more!
http://dotnetjunkies.com/WebLog/bsblog/archive/2004/04/27/12229.aspx

Furthermore, I'd also suggest you can create one xml web service with the
ADO and then pass the xml directly to the OWC. One kb article introduces
more:
HOW TO: Use the Office Web Components with XML Data Generated by an XML Web
Service Created Using ASP.NET
http://support.microsoft.com/?kbid=315695

In addition, if your scenario needs OLAP, another MSDN article will give
one good sample on this for you:
Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis
Services and Office XP
http://msdn.microsoft.com/msdnmag/issues/03/10/olap/default.aspx

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong XU
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Brian Hman]

Hello Wei-Dong XU,

The example at
http://dotnetjunkies.com/WebLog/bsblog/archive/2004/04/27/12229.aspx

worked great once I cannibalized some of the code for my application.

Thank you for your assistance,
Brian

 

[Wei-Dong XU [MSFT]]

:0) Great news! You are very welcome!

Best Regards,
Wei-Dong XU
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.