Asp.net reports in the pivot table

[Brajesh Jain]

Hello,

we r making a three tier application in which front end is Asp.net. In
application we r supposed to show some reports. previously we were
showing those reports in the excel and for that we were binding our
dataset to datagrid contol on a web page and after that we were
changing the content type of the page to excel, so reports were coming
in excel.

this.EnableViewState = false;
Response.Clear();
Response.ClearContent();
Response.ContentType = "application/vnd.ms-excel" ;

But now client wants those reports in the pivot table. can anybody
help in that, because i m not sure that as by changing the content
type of the reports were coming in excel similar way we can show in
pivot tables also or we have to do it some other way.

Thanks & regards,
Brajesh

 

[Brajesh Jain]

I tried to solve the problem by using OWC10. but problem is that
interactivity is not coming in browser. as i am using same machine for
testing so case of not having install office xp web component is not
there. Can anybody help in that.

i m writing following code for that in script

document.Form1.Pivotcontrol1.ConnectionString = "Provider=MSPersist"
document.Form1.Pivotcontrol1.CommandText =
"http://localhost/Brajesh/PivotTest/webform2.aspx"
document.Form1.Pivotcontrol1.DisplayFieldList = true
var v = document.Form1.Pivotcontrol1.ActiveView
var c = document.Form1.Pivotcontrol1.Constants
v.ColumnAxis.InsertFieldSet(v.FieldSets("TotalPosition"))
v.RowAxis.InsertFieldSet(v.FieldSets("TotalProposedCandidates"))
v.DataAxis.InsertFieldSet(v.FieldSets("TotalOpenPosition"))
var t = v.AddTotal("SumTotalPosition",
v.FieldSets("TotalPosition").Fields(0), c.plFunctionSum)
v.ColumnAxis.InsertTotal(t)

here "http://localhost/Brajesh/PivotTest/webform2.aspx" is giving me
xml file which i m using as a datasource

Thanks & regards
Brajesh