OWC Pivot Table problem

[richi]

Hello

I am following the knowledge base article 303016
"How to use a DataSet with the Office XP Chart Component and ASP.NET"

Using VB script on an HTML page I am setting the connection string to
"Provider=MSPersist" and the command text to an aspx page which handles the
retreiving of data from SQL Server and in turn transforming the dataset to
XML using XSLT.

The problem i am encountering is although the dataset contains 10 or so
records when this data is attached to the Chart/PivotTable i only see the
first record.

Has anybody come across this problem and if so please put me out of my
misery and tell me what i am doing wrong!!!

Many thanks in anticipation

Rich

 

[Hendrik]

Hi Rich,

I have just tried the same thing, and didn't encounter the problem you
mentioned.
You may want to try this resource for help:

http://www.codebetter.com/blogs/brendan.tompkins/archive/2004/04/27/12229.aspx

Regards,
Hendrik