owc10 total label font

[Vincent]

i can't seem to find a way in the command and options window to set the font for the "Total"/"Grand Total" labels. i can set the font for the data, but not the label. in fact when i click on a total row or column and view the "captions" tab in command and options window, the font section is grayed. what am i missing?
thanks,
vincent

 

[Diego]

view.FieldLabelBackColor = "MidnightBlue"
view.FieldLabelForeColor = "Gold"
view.TotalBackColor = "DarkGray"


oDimension1.Fields(0).GroupedBackColor = "MidnightBlue"
oDimension1.Fields(0).GroupedFont.Color = "Lavender"
oDimension1.Fields(0).SubtotalBackColor = "Gold"
oDimension1.Fields(0).SubtotalLabelBackColor = "Gold"
oDimension1.Fields(0).SubtotalLabelFont.Bold = True
oDimension1.Fields(0).SubtotalLabelFont.Color = "Lavender"

-----Original Message-----
i can't seem to find a way in the command and options

window to set the font for the "Total"/"Grand Total"
labels. i can set the font for the data, but not the
label. in fact when i click on a total row or column and
view the "captions" tab in command and options window,
the font section is grayed. what am i missing?

 

[Vincent]

thanks for the response. i should have mentioned that i can do it with code. but i want my users to be able to change the font properties from the GUI, and when it comes to the "Total" labels, i can find no way to do it. i'm wondering if it's because i just haven't found the way, or because it's not possible, and if so, why? like i said previously, when you get to the captions tab in commands and options for a total field, the font properties are grayed.

--vincent


view.FieldLabelBackColor = "MidnightBlue"
view.FieldLabelForeColor = "Gold"
view.TotalBackColor = "DarkGray"


oDimension1.Fields(0).GroupedBackColor = "MidnightBlue"
oDimension1.Fields(0).GroupedFont.Color = "Lavender"
oDimension1.Fields(0).SubtotalBackColor = "Gold"
oDimension1.Fields(0).SubtotalLabelBackColor = "Gold"
oDimension1.Fields(0).SubtotalLabelFont.Bold = True
oDimension1.Fields(0).SubtotalLabelFont.Color = "Lavender"

-----Original Message-----
i can't seem to find a way in the command and options

window to set the font for the "Total"/"Grand Total"
labels. i can set the font for the data, but not the
label. in fact when i click on a total row or column and
view the "captions" tab in command and options window,
the font section is grayed. what am i missing?

 

[Dip]

Hi Vincent,
The label for Total and Subtotal can not be changed in OWC10. This is
some of the other limitations of OWC. I was also searching these for
quite a while. This is really bothering my cutomers as well as they want
to see "Total of Expenditure Account" rather than just "Total" which
does not makes any sense.
I hope Microsoft will fix it soon.
if you find any work-around please let me know.
Thanks.
Dip