Pivot Table is not shown in ASP.Net 2.0 web form

[Raghu]

Hi All,

I have developed ASP.Net 2.0 application to view data from olap in
pivot table.
I have followed exact steps given in examples. Below is piece of code
which generates proper XMLData for value property of param tag.

But in UI (web form) I can not see any data or pivot table being
created.

PivotTableClass objTable = new PivotTableClass();
string strConnection =
ConfigurationManager.AppSettings["OLAPConnectionString"];
objTable.ConnectionString = strConnection;
objTable.DataMember = "Cube1l";
string strXML = objTable.XMLData;
prmSales.Attributes.Add("value", strXML);

I have installed OWC11 in my system. Microsoft.Office.Interop.Owc11
dll is shown in GAC.

I have given the same reference in my project.

I have Windows 2000 profession SP4.

Need to know why pivot table is not created and shown.
Is there something I am missing or something else needs to installed.
Appreciate your help.

Regards,
Raghu

 

[Alvin Bruney [MVP]]

Is there something I am missing
Yes, indeed. The object you create is not viewable on the client. It's a
server side object. You'll need to use the client-side object if you want to
*see* a pivot table.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley