[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

office web component 11 with VB.NET

Posted on 2004-09-21
6
Medium Priority
?
628 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

649 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