Bind OWC Chartspace with Pivot Table

[Sukhdev]

Hi,
I have been able to generate the Pivot by supplying my own MDX at runtime.
Could anybody please help me in binding the OWC Chartspace to the Pivot table?

That means if any further changes are made to the Pivot table by manually
dragging or removing fields from it, the Chartspace displays the chart.

Please note, I'm creating a Windows application using VB.NET.

Here's what I did:
myChartspace.Datasource = myPivotTable ' Error: --> specified cast is not
valid

Next i tried
myChartspace.Datasource = myPivotTable.datasource ' No Error, no graph
generated, no effect at all

Next i tried
myChartspace.Datasourcename = "myPivotTable" ' Error --> Catastrophic failure

Please show me a way how to bind the chartspace to the pivot table.

Thank you.
Sukhdev.

 

[PierreDechaine]

Are you using JavaScript to set your datasource property?

If so then you should use something like this:

var ptable=document.getElementById('PivotTable1');
var chart=document.getElementById('ChartSpace1');

chart.DataSource = ptable;
//To make sure all ags get plotted
chart.PlotAllAggregates=1;

HTH, Pierre

 

[Sukhdev]

Hi,
Thanks for answering, but that's not what i was looking for.

I'm creating a Windows Application, using VB.NET. My App has got the OWC11
components added to.

Here I tried the following in VB.NET
myChartSpace.DataSource = myPivotTable --> 'Error: Specified cast is not valid

However, when I try the same in VB6, it's perfect. The chartspace is bound
to the pivottable and there's no error.

Here's what I think, VB6, does some internal conversion so there's no error.
But VB.NET we must explicity specify what it is. And this is what i don't
know how to do.

could you or anyone else please help me with this. in VB.NET

thanks.
Sukhdev

 

[Sukhdev]

Hi,
I've found the solution.
There's a slight difference in binding charts to pivot table in vb6 and vb.net

Below is the solution for both vb6 and vb.net
In VB6
--------
myChartspace.Datasource = myPivotTable

In VB.NET
-----------
myChartspace.Datasource = myPivotTable.GetOcx

Reason: In VB6 the datasource property of the myChartspace has a default
value as myPivotTable
Whereas, in VB.NET, the OWC component DOES NOT support early binding, so
therefore there is no default property for the DataSource.

We must manually use GetOcx method, to return the object that reprsents the
ActiveX Control.

Cheers!!
Sukhdev.

 

[PierreDechaine]

That is interesting to see. The GetOcx method does not show up in
intellisense. If you set Option Strict on your class you will have to cast
your object like so:

cSpace.DataSource = CType(pTable.GetOcx, msdatasrc.DataSource)
cSpace.PlotAllAggregates =
ChartPlotAggregatesEnum.chPlotAggregatesSeries

Just thought that I would share my findings, Pierre

 

[Guest]

try this:
myChartspace.Datasource = myPivotTable.object