Subtotal Formatting
I'm still new to reporting services so forgive me for the newbie question...
I have a matrix with column and row subtotals. How do I format the actual subtotal data!?! If I select the "Total" cell or the the subtotal row/column it will only format the Total labels, not the subtotaled data. It's also not possible to select the cells where the subtotalled data would be to try and apply formatting(greyed out).
Thanks in advance!
[435 byte] By [
AussieRS] at [2007-12-30]
Have you tried to select the whole matrix row that holds the subtotals? Click on a cell in the row and then on the grey box to the left of the row's leftmost cell.
When the whole row is selected you can format it. But you can't have different formats on different columns on that row.
Hi there, I too had this problem.
In the layout tab I found a small triangle in the top right hand corner of each subtotal cell on the matrix. Clicking that triangle and then going to the properties allowed me to format the subtotal data cells background so that label and data were the same.
Cheers
Rich
Has this question been addressed yet? I'm also using Report Builder, and I can make changes (center, fill and border) to the subtotal cells. When saved and viewed, the formats are displayed correctly.
However, when returning to Report Builder to make further changes to the report, most - not all - subtotal formats revert back to the default, and need to be reset again. Needless to say, this gets rather old after resetting the formatting for the 15th time.
Is there a fix coming for this very annoying bug?
Tks & B/R
Formatting would then be possible yes,
but if you use an expression, how do you reference a cell in the subtotal that you want to format? Sample Problem Expression: =iif(
VALUE = 'Total Employees', "White", "Black") ? Because a subtotal can give you more than one cell to format...