Re: OWC11 with Vb.Net

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You will need to use client side events to do your updates. On the submit click event, you will need to write MDX queries targetted at the cube. If you don't know MDX, you can learn by buying a book on amazon.

--
Regards,
Alvin Bruney

Auther Plug
OWC Blackbook now on download at www.lulu.com/owc

"raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A92EF46F-6E35-4E33-B0A8-AE90E6B5710A@xxxxxxxxxxxxxxxx
its not pointing to cube directly connecting to the SQL Server, I have
mentioned as "SQL Server Connection String" since I am posting in the forum.
This code works absolutly fine but here if you look at the code its using
Response.Write(pivotTable1.HTMLData) so the pivot report is going to be
static but where as I want to display interactive report. Can you help me out
how I can alter this code to generate the interactice report for the pivot
tables.

Regards,


"Alvin Bruney [ASP.NET MVP]" wrote:

What is this pointing to? "SQL Server Connection String"
Is it pointing to SQL server or a cube? The pivot table writes MDX
expressions, SQL server does not understand MDX expressions.
--
Regards,
Alvin Bruney

Auther Plug
OWC Blackbook now on download at www.lulu.com/owc

"raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4A4C16C9-E489-416A-83EB-C0CE038A06F1@xxxxxxxxxxxxxxxx
> Yes, I am talking about the Pivot Table itself. Here is the code I am
> using
> to display the pivot table (static ) but I need to generate the dynamic
> pivot
> table with the similar code.
>
> Dim pivotTable1 As New Microsoft.Office.Interop.Owc11.PivotTable
>
> ' Creates connection to Northwind and Customers table.
> pivotTable1.ConnectionString = "SQL Server Connection String"
> pivotTable1.DataMember = "Table Name"
>
>
> ' Automatically populates the PivotTable Component.
> pivotTable1.ActiveView.AutoLayout()
>
> 'With pivotTable1.ActiveView
> ' .FilterAxis.InsertFieldSet.FieldSets("Country")
> ' .RowAxis.InsertFieldSet.FieldSets("Region")
> ' .DataAxis.InsertFieldSet.FieldSets("CompanyName")
> ' .DataAxis.InsertFieldSet.FieldSets("ContactName")
> ' .DataAxis.InsertFieldSet.FieldSets("Phone")
> ' .FieldSets("Country").FilterMember = "USA"
> 'End With
> pivotTable1.DisplayDesignTimeUI = True
> pivotTable1.DisplayExpandIndicator = True
> pivotTable1.DisplayFieldList = True
> pivotTable1.AllowDetails = True
> pivotTable1.ActiveView.AllowEdits = True
> pivotTable1.ActiveView.AllowAdditions = True
> pivotTable1.ActiveView.AllowDeletions = True
> pivotTable1.DisplayToolbar = True
>
> Response.Write(pivotTable1.HTMLData)
>
> Regards,
>
> "Alvin Bruney [ASP.NET MVP]" wrote:
>
>> That is by design, only pivot table has interactivity.
>>
>> -- >> Regards,
>> Alvin Bruney
>>
>> Auther Plug
>> OWC Blackbook now on download at www.lulu.com/owc
>>
>> "raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:BDF8AAD7-E54C-4595-B06A-88475DA12DBF@xxxxxxxxxxxxxxxx
>> > Alvin,
>> >
>> > Thanks for the reply. Actually I found couple of the snippets at >> > msdn
>> > but
>> > when I use the OWC code behind with sql server (no OLAP) I could >> > able
>> > to
>> > generate the pivot table but its not interactiv mode. Can you >> > suggest
>> > me
>> > any
>> > samples.
>> >
>> > Thanks for the help.
>> >
>> > Regards,
>> >
>> > "Alvin Bruney [ASP.NET MVP]" wrote:
>> >
>> >> google this newsgroup, over the years, there are several hundred
>> >> snippets
>> >> that you can use to do what you want.
>> >>
>> >> -- >> >> Regards,
>> >> Alvin Bruney
>> >>
>> >> Auther Plug
>> >> OWC Blackbook now on download at www.lulu.com/owc
>> >>
>> >> "raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:277EFBCE-9423-41A2-AA71-0957D7A04C5B@xxxxxxxxxxxxxxxx
>> >> > I have an article at MSDN,
>> >> > http://msdn.microsoft.com/en-us/library/aa188489(office.10).aspx#vsofficedev_topic11
>> >> >
>> >> > This might be helpful to others
>> >> >
>> >> > Regards,
>> >> >
>> >> > "raj" wrote:
>> >> >
>> >> >> Hi,
>> >> >>
>> >> >> Appreciate if anybody can post the sample code for the vb.net >> >> >> web
>> >> >> application using OWC11 component (not using OLAP). I am not >> >> >> able
>> >> >> to
>> >> >> find
>> >> >> the
>> >> >> samples anywhere. Here is my case
>> >> >>
>> >> >> I need to pull the data from SQL Server 2005 and display on the
>> >> >> webpage
>> >> >> using OWC11 component. And design the Pivot table like rows,
>> >> >> column,
>> >> >> filters.
>> >> >>
>> >> >> Open the Excel file and Save as Webpage is definetly not my
>> >> >> solution.
>> >> >>
>> >> >> Thanks in advance
>> >>
.

Relevant Pages

  • Re: OWC11 Pivot Table - MDX parsing problem?
    ... The original MDX query is below. ... This MDX is generated by an Excel pivot table. ... the code below will again produce a OWC11 pivot table that does not ...
    (microsoft.public.office.developer.web.components)
  • Re: OWC11 Pivot Table - MDX parsing problem?
    ... owc and excel uses mdx in different manners. ... to excel function from owc in certain situations. ... The original MDX query is below. ... This MDX is generated by an Excel pivot table. ...
    (microsoft.public.office.developer.web.components)
  • Re: OWC11 Pivot Table - MDX parsing problem?
    ... with a web page that has the owc pivot table. ... can open the OWC source code and find out what the bug is. ... The original MDX query is below. ...
    (microsoft.public.office.developer.web.components)
  • Calculated members do not display in Excel pivot table using 3rd party provider
    ... Calculated members display in the pivot table fine when I use a cube from MS ... Here is mdx that the ...
    (microsoft.public.sqlserver.olap)
  • edit excel pivot table datasource when moving onto XP OS from NT4.0
    ... I need to refresh the data of all of my pivot tables, ... We simply moved SQL Server 2000 databases and upgraded on our CLIENT ... ODBC system dsn built via control panel.We upgraded client ... This error message tells me that the excel pivot table datasource file ...
    (microsoft.public.sqlserver.odbc)