J
Jonathan
Hi All,
Having huge difficulty with getting OWC10 PivotTable to look how I want it
to. Questions:
1) When I autofit the total headings they don't fill the entire column -
there is a gap that looks quite confusing when there are many columns. I
would like the total headings to completely fill the column widths but can't
see how to do this.
PivotTable1.ActiveView.AddTotal("VALUE TOTAL",
PivotTable1.ActiveView.FieldSets("VALUE").Fields("VALUE"),
plFunctionSum).AutoFit=True
2) Is there any way to colour the resulting grid of column totals
individually rather than have a single mass of 1 color. I'd like to alternate
the column colors for readability but once again I am confused!
The main problem is lack of detailed documentation and having to guess what
objects do what. I have hunted down every article I can find but there is no
good overview of the whole object hierarchy. Worse case I will export data
from the PivotTable and reformat in the Spreadsheet component but the
end-user will lose some functionality.
Any help much appreciated!
Thanks, Jonathan.
Having huge difficulty with getting OWC10 PivotTable to look how I want it
to. Questions:
1) When I autofit the total headings they don't fill the entire column -
there is a gap that looks quite confusing when there are many columns. I
would like the total headings to completely fill the column widths but can't
see how to do this.
PivotTable1.ActiveView.AddTotal("VALUE TOTAL",
PivotTable1.ActiveView.FieldSets("VALUE").Fields("VALUE"),
plFunctionSum).AutoFit=True
2) Is there any way to colour the resulting grid of column totals
individually rather than have a single mass of 1 color. I'd like to alternate
the column colors for readability but once again I am confused!
The main problem is lack of detailed documentation and having to guess what
objects do what. I have hunted down every article I can find but there is no
good overview of the whole object hierarchy. Worse case I will export data
from the PivotTable and reformat in the Spreadsheet component but the
end-user will lose some functionality.
Any help much appreciated!
Thanks, Jonathan.