Source=S1SPRODUCTION Initial Catalog=Foodmart 2000 "ĭim oView As OWC11.PivotView = pivotcontrol1.ActiveViewġ. Pivotcontrol1.ConnectionString = "Provider=MSOLAP.2 Data 'Put user code to initialize the page here
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As Public pivotcontrol1 As New OWC11.PivotTableClass Pivotcontrol1.CommandText property to somthing? I'm trying to connect to an Analysis Services Server usingĪsp.Net/Office Web Controls using the PivotTableClass, but the webįorm display the control with no active buttons. Using OWC 11 to connect to OLAP server in ASP.Net Hi, What does Microsoft have out there that would be compatible Platforms (Mac and PC) but many have different versions of Excel (XP, 2002,Ģ003, 2000). I want to program a couple of Excel reports for both Mac Users and PC usersĪnd have them access from a web site. Programming Excel Efficiently - HELP! My head is exploding with the 500 different ways shown on Microsoft's siteĬan anyone offer the best solution to the following:
Know whether pivotTable is scrollbar or not! Any one tell me how to do it? PivotTable is larger than vb form, I can't view some parts content? I don't I would like to display pivotTable in vb, But when anlysis result table in How to add scrollbar when pivotTable is larger than vb form? Dear all,
What is wrong ? Something with registration or just me not understanding the and then I can only pick a Range object from the Placed a pivottable on a VB6 form, works fine, I can populate it with dataīut I can not create a NEW Pivottable object from code Installed Office XP + webcomponents from the CD I am trying to use Office XP web components with a VB6 application. Does anyone of any different configuration for a windows 2003 server, or if the server side components even work on a windows 2003 server? Not sure if it's a possible permission problem in windows 2003 server. Also, I can run parts of the app that use the spreadsheet component client side with no problems. I had the same code working fine on a windows 2000 box. QueryInterface for interface .ISpreadsheet failed. When accessing the spreadsheet object server-side, I get the following error OWC 10 on Windows Server 2003 I installed OWC10 on a windows 2003 server (IIS 6).