OWD Pivot table does not look like Excel Pivot table

[blaseyj]

Can anyone tell me if there are any properties that can be set to make
the OWC pivot table look like the Excel pivot table?

Thanks,
June

 

[Alvin Bruney - ASP.NET MVP]

the OWC only approaches Excel look-a-like it is not an exact replica

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[blaseyj]

I realize they are not the same, I am just trying to get the OWC
behavior to be like that of Excel. I am looking for a way to have the
(grand)totals display immediately instead of the details (like Excel).
I am trying to set properties client side. Any ideas?

 

[RayTheOtherRay]

June,

I don't know if this is what you're looking for, or not. In our web
page containing a pivot table and pivot chart, it showed only the years
when we published it from Excel, even though it was expanded to months
in Excel. We use the following code to expand the year level of the
shared dimension in the OLAP cube so that the pivot table would expand
the Year level of the Calendar dimension.

<script language="javascript">

// Initialize object variables
var pt = document.getElementById('Book1_24147_PivotTable');
var pv = pt.Activeview;
var ra = pv.RowAxis;

// Expand the Year level to view Months
var fscalendar = ra.FieldSets('[Calendar]');
var fldyear = fscalendar.Fields('[Calendar].[Year]');
fldyear.Expanded = 'True';

</script>

You could probably determine in which level you are interested and set
the Expanded property to 'False'. My scripting language of choice
(it's the first one I learned!) is JavaScript. I imagine this will
translate to VB fairly easily.

Hope this helps!
Ray <><

 

[blaseyj]

Thanks Ray, I will give this a shot!

June