Solved

office web component 11 with VB.NET

Posted on 2004-09-21
6
621 Views
Last Modified: 2008-01-09
Hi,
I'm creating a windows application in vb.net and I'm using a Pivot table to access a local cube(sales.cub) and a chartspace object to view the graph.

My question is how to populate the chartspace in VB.NET. In other words, how do I bind the chart to the Pivot table, so that each time the pivot table changes the charting objects changes too.

Thank you.

Sukhdev.
0
Comment
Question by:sukhdev
  • 2
6 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 12110516
looking at this KB you can use an xml file as an intermediate strucutre for the datastorage

title : HOW TO: Use the Office Web Components with XML Data Generated by an XML Web Service Created Using ASP.NET
source : http://support.microsoft.com/default.aspx?scid=kb;en-us;315695

couldn't find a direct way of sharing the data between the 2 components through a  datasource property on both but maybe someone else will
0
 

Author Comment

by:sukhdev
ID: 12235787
I'm still trying to do it... haven't been successful still....  please help me.....

thank you.
0
 

Author Comment

by:sukhdev
ID: 12530066
Hi guys... I've found the solution...

Let me share it... maybe someone else might be looking for the same thing.

There's a slight difference in binding charts to pivot table in vb6 and vb.net

Below is the solution for binding a chartspace to a pivot table in VB6
In VB6
--------
myChartspace.Datasource = myPivotTable


Below is the solution for binding a chartspace to a pivot table in VB.NET
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.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12534342
Closed, 125 points refunded.

modulo
Community Support Moderator
Experts Exchange
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now