OWC Pivot Table - Can't format group or grand total

G

garyn

I'm having a problem formatting my pivot table labels. When I apply grouping to items, I lose the formatting. The group labels and grand total revert back to Arial 10. This is my code:

<script language = "javascript">

var name = "Verdana";
var size = 8;

var v = document.PivotTable.ActiveView;
v.FieldLabelFont.Name = name;
v.FieldLabelFont.Size = size;
v.TotalFont.Name = name;
v.TotalFont.Size = size;
v.HeaderFont.Name = name;
v.HeaderFont.Size = size;

// set font name and size for all detail and subtotal fields.
for (var fs = 0; fs < v.FieldSets.Count; fs++) {
var fldSet = v.FieldSets(fs);
for (var f = 0; f < fldSet.Fields.Count; f++) {
var fld = fldSet.Fields(f);
fld.DetailFont.Name = name;
fld.DetailFont.Size = size;
fld.SubtotalFont.Name = name;
fld.SubtotalFont.Size = size;
fld.SubtotalLabelFont.Name = name;
fld.SubtotalLabelFont.Size = size;
fld.GroupedFont.Name = name;
fld.GroupedFont.Size = size;
}
}
</script>

This is in OWC 10. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top