Re: OWC11 with Vb.Net

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

  • 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)
  • Re: OWC11 with Vb.Net
    ... Is it pointing to SQL server or a cube? ... The pivot table writes MDX expressions, SQL server does not understand MDX expressions. ... OWC Blackbook now on download at www.lulu.com/owc ... pivotTable1.ConnectionString = "SQL Server Connection String" ...
    (microsoft.public.office.developer.web.components)
  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)
  • Re: Transpose data for cube
    ... If both relational SQL Server 2005 and AS 2005 are an option, ... Using PIVOT and UNPIVOT ... Deepak Puri ...
    (microsoft.public.sqlserver.olap)
  • Re: Newbie: SQL Server connection, help needed
    ... Mike Epprecht, Microsoft SQL Server MVP ... > trying to setup an ODBC connection from another XP and win2000 machines. ... Not associated with a trusted SQL Server connection. ...
    (microsoft.public.sqlserver.connect)