Hi,
have had a look at the archives and there is some good info there
about having different formatting for subtotals as compared to the
actual data columns. What I want to do though, is have the same
formatting applied to the subtotals as to the data columns.
I have 9 data columns which all have a formula applied to the font
colour setting along the lines of:
=iif( sum(Fields!PD_Sales_Var_LY.Value) < 0 , "Red","Black")
This works fine in the column and in preview, it works on the subtotals
as well but when I deploy to the server, it loses the formatting on the
subtotals and all numbers are in default "Black"
Any ideas ?
Rgds
GeoffUpdate on this
It appears that the subtotals will only inherit the formatting from
data columns if there is absolutely no formatting applied to the
subtotals themselves. I made the mistake of adding a border property to
the subtotals, thinking it would not affect inheritance of the font
property but obviously it does.
Rgds
Geoff
No comments:
Post a Comment