Right Align numbers/text in Pivot Table OWC

[Kasper Skjødt Nielsen]

Hi

I have a small OLAP Pivot TAble :

Set oView = PTable.ActiveView

oView.UseProviderFormatting = True

'Add Dimensions to the column, row, and filter axes.

' Filteraxis
oView.FilterAxis.InsertFieldSet oView.FieldSets("Date")
' Row Axis
oView.RowAxis.InsertFieldSet oView.FieldSets("Region")
oView.RowAxis.FieldSets("Region").Fields("Region").Expanded = True

oView.RowAxis.DisplayEmptyMembers = False

'Data area.

oView.DataAxis.InsertTotal oView.Totals(""Visitors"")
oView.DataAxis.InsertTotal oView.Totals(""Customers"")
oView.DataAxis.InsertTotal oView.Totals(""Sales"")



How do I make the dataaxis values right-aligned ?

Does anyone have a link to somwhere with definition of different
properties of the different objects in OWC? (like the "Expanded"
property of the RowAxis).

Kasper Nielsen

 

[Alvin Bruney [MVP]]

How do I make the dataaxis values right-aligned ?

Use the HAlignment property of the pivotlabel object for the specified axis.

Does anyone have a link to somwhere with definition of different

There is no link or resource available on the web. Either use the help file
or buy the Office web components black book with .net. It contains the full
object hierarchy for each component so you can look up properties, methods
and events with full description and sample code snippets.

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

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://tinyurl.com/27cok