Results 1 to 11 of 11

Thread: Help: Office Web Components (OWC)??

  1. Dec 8th, 2003, 01:42 AM #1
    ddolheguy
    ddolheguy is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2003
    Posts
    16

    Question Help: Office Web Components (OWC)??

    I am very new to Office Web Components (OWC) and need to place a spreadsheet into a web page and load it with data from an SQL database.

    I currently have the following in my default.aspx page:

    Code:
    <body>
   <form id="Form1" method="post" runat="server">
      <OBJECT id="ss">{WEB COMPONENT OBJECT}</OBJECT>
   </form>
</body>
    I would like to be able to control the OBJECT from within VB.NET.

    Can this be done and how??

    I am able to use a client side scripting language to control the spreadsheet, but need to use ASP.NET language as I want to integrate into a .net web site.
    Reply With Quote Reply With Quote
  2. Dec 8th, 2003, 12:24 PM #2
    MasterBlaster
    MasterBlaster is offline
    Addicted Member MasterBlaster's Avatar
    Join Date
    Jul 2002
    Location
    Seattle
    Posts
    196
    If I'm not mistaken an owc spreadsheet can be bound to xml. I've only ever used the owc pivot table, but I am guessing it is not all that different. this is a pretty good write up on olap and owc reporting. It also shows how to use a web service to control it which I think is what your looking for. Hope this helpshttp://msdn.microsoft.com/msdnmag/is...P/default.aspx
    "And most of the evils of society can, in fact, be cured through information. We have a society that has been disinformed and based on the disinformation has made irrational choices. And that's what I mean by 'ignorance.' People, who ordinarily might be smart, are deprived of the data by which to make a rational decision, don't have the data to do it."
    Frank Zappa
    Reply With Quote Reply With Quote
  3. Dec 8th, 2003, 03:11 PM #3
    ddolheguy
    ddolheguy is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2003
    Posts
    16
    Thank you for the response, but unfortunately I am not looking for an XML solution.

    I have developed an intranet reporting web site and need to pull data directly from an SQL database. I was intending on using ADO.net to control this end of the equation.

    What I am trying to do is communicate with the Spreadsheet object from the VB.NET backend code.
    Reply With Quote Reply With Quote
  4. Dec 8th, 2003, 05:10 PM #4
    MasterBlaster
    MasterBlaster is offline
    Addicted Member MasterBlaster's Avatar
    Join Date
    Jul 2002
    Location
    Seattle
    Posts
    196
    Yes I know and that is exactly what I gave you. If you look at the sample, the properties of an owc control should be able to be controled using it's xmldata property. This may sound like that property is actually the data being displayed. It is not. It is xml that can set the controls data source, connection type, hell even the font colors if you want. you can create an aspx page or web service(which I prefer and is shown in the example I gave you) using c#/vb to create that xml data and control the owc from your server. You can use ADO OLAP, XML or whatever as your datasource. It dosn't matter.
    "And most of the evils of society can, in fact, be cured through information. We have a society that has been disinformed and based on the disinformation has made irrational choices. And that's what I mean by 'ignorance.' People, who ordinarily might be smart, are deprived of the data by which to make a rational decision, don't have the data to do it."
    Frank Zappa
    Reply With Quote Reply With Quote
  6. Dec 8th, 2003, 05:17 PM #5
    MasterBlaster
    MasterBlaster is offline
    Addicted Member MasterBlaster's Avatar
    Join Date
    Jul 2002
    Location
    Seattle
    Posts
    196
    Mabe this will clarify it a bit.

    1.Create a spreadsheet object in you vb code behind or web service.

    2. set all of It's properties to what you want them to be

    3. calling yourspreadsheet.xmldata should return xml containing everything you need to create an exact mirror of you server side object on your client.

    4. pass the xml to you client

    5. assign th xmldata created on the server to the client's xml data property.


    simple as that. remember I am assuming that the owc version you are using has the xml data property.
    "And most of the evils of society can, in fact, be cured through information. We have a society that has been disinformed and based on the disinformation has made irrational choices. And that's what I mean by 'ignorance.' People, who ordinarily might be smart, are deprived of the data by which to make a rational decision, don't have the data to do it."
    Frank Zappa
    Reply With Quote Reply With Quote
  7. Dec 8th, 2003, 05:49 PM #6
    ddolheguy
    ddolheguy is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2003
    Posts
    16
    MasterBlaster


    Thank you so much for explaining this to me... I am still a little confused on the XML side of things as from my previous experience I am used to thinking that XML data means XML web files...

    I will do some reading on the microsoft site and have a look at the demo code they have supplied...

    Thanks heaps once again.
    Reply With Quote Reply With Quote
  8. Dec 8th, 2003, 05:58 PM #7
    MasterBlaster
    MasterBlaster is offline
    Addicted Member MasterBlaster's Avatar
    Join Date
    Jul 2002
    Location
    Seattle
    Posts
    196
    No problem. The nice thing about this is you don't have to know anything about xml. All you are doing is passing a string from a web service or asp.net page to client side script and setting a property on the client. all of the xml reading and generation is done for you by the OWC.
    "And most of the evils of society can, in fact, be cured through information. We have a society that has been disinformed and based on the disinformation has made irrational choices. And that's what I mean by 'ignorance.' People, who ordinarily might be smart, are deprived of the data by which to make a rational decision, don't have the data to do it."
    Frank Zappa
    Reply With Quote Reply With Quote
  9. Dec 9th, 2003, 05:47 PM #8
    ddolheguy
    ddolheguy is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2003
    Posts
    16
    Masterblaster...

    Sorry to ask all these questions, but do you know if it's possible to use a straight SQL Query through an ADO connection with the Pivot Table example you have given me?

    I have been looking at the example and setup an SQL Server 2000 with Analysis Services installed, but I am unable to generate a data cude through the web site provided.

    I have setup a 'Sales' cube on the FoodMart 2000 database and when using the Analysis Manager and processing the cube I receive an 'unspecified error' when I try to browse the data cube. So I am guessing this maybe related to my problem...

    Sorry to hit you with all this stuff, but initially I would like to make this as easy as possible.
    Reply With Quote Reply With Quote
  11. Dec 9th, 2003, 05:55 PM #9
    MasterBlaster
    MasterBlaster is offline
    Addicted Member MasterBlaster's Avatar
    Join Date
    Jul 2002
    Location
    Seattle
    Posts
    196
    I don't think you can with the pivot table. I believe the you can using the owc spreadsheet though.
    "And most of the evils of society can, in fact, be cured through information. We have a society that has been disinformed and based on the disinformation has made irrational choices. And that's what I mean by 'ignorance.' People, who ordinarily might be smart, are deprived of the data by which to make a rational decision, don't have the data to do it."
    Frank Zappa
    Reply With Quote Reply With Quote
  12. Dec 9th, 2003, 06:28 PM #10
    ddolheguy
    ddolheguy is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2003
    Posts
    16
    I don't suppose you know how too?? Or if you know of any examples???
    Reply With Quote Reply With Quote
  13. Apr 3rd, 2006, 05:27 AM #11
    brian84
    brian84 is offline
    Junior Member
    Join Date
    Nov 2005
    Posts
    16

    Re: Help: Office Web Components (OWC)??

    masterblaster:

    do you know how to render a chart to owc chart in reporting service......
    i manage to render a matrix to a pivot table only.....

    thank you.....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width