VB.Net - Bind Pivot & Chart

[Antoine Prevot]

Hi there,

Sorry to disturb you with this simple problematic, but i'm havin headaches ...

I'm trying for two hours to bind a PivotTable and a ChartSpace (OWC10 or 11,
issue is the same) and nothing works My method is pretty simple :

CS.DataSource = PT

This works on most programming environnements (including VB6 and
JavaScript), but in a vb.net application, I only get an "Invalid cast"
exception ! Can anybody help me ? I cannot find anything by myself, and
google doesn't help me ... everybody seem to use OWCs on a web context and
never in a client/server application :-/

 

[bren]

I'm developing a WinForm app.

This works for me. I believe I found this code in this forum.

AxChartSpace1.DataSource = CType(AxPivotTable1, AxHost).GetOcx()

Bren

 

[Antoine Prevot]

GREAT ! It works !!!

Thank you Bren, i owe u one