Re: OWC11 with Vb.Net

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

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: Displaying Text, not numbers, in Pivot Table
    ... Pivot tables are numeric. ... MS Excel MVP ... I am wondering if there is anyway to display ... interactive so it does not become overwhelming with all the summaries on ...
    (microsoft.public.excel.newusers)
  • RE: Pivot Table (same level hierarchy fields)
    ... just play with the auto formats off the format menu.. ... > I understand that Pivot Tables aggregate data based on hierarchy's--however, ... I would love to be able to display item ... I'm new to vba, but I ...
    (microsoft.public.excel.programming)
  • Access 2003 pivot table subform
    ... reason, it started failing to display the data when the pivot table on open, ... I get a message where the pivot table data ... “The query could not be processed: ... form itself, uses a query to get its data, and the query filters are driven ...
    (microsoft.public.access.forms)
  • Pivot table permissions issue
    ... I have a pivot table form based on a query on several tables. ... display is now of the weeks last chosen. ... non Admins user receives no warning they are restricted from changing the ...
    (microsoft.public.access.security)
  • Re: commands dialog hidden in Portfolio Analyser view
    ... this setting only controls the initial display of the Portfolio ... Same goes with the display of the toolbars for them as well. ... > both for the pivot table and the chart. ...
    (microsoft.public.project.pro_and_server)