AussieRS


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!



Re: Subtotal Formatting

Michael Legner


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.





Re: Subtotal Formatting

smeganb

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






Re: Subtotal Formatting

Jim From Florida

I don't see the triangle. I am using the Browser-based Report Builder from Sql Reporting services 2005. Is it in here, or Must I use the Business Intelligence Development Studio

Thanks in advance.





Re: Subtotal Formatting

PorkyPete

Excellent post - I've looked high and low for the solution to this problem!

Cheers

Pete





Re: Subtotal Formatting

ko712000

I am having a similar problem. Does anyone now how to format the sub-totals column border What I want to do is have a solid border around the totals column but only the totals column. I do not want the other columns to have a border.





Re: Subtotal Formatting

KLWSearch

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





Re: Subtotal Formatting

Francois Wiid

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...




Re: Subtotal Formatting

Dolllar Dude

I found that it is possible to control the formating of the textbox by working out whether or not it is currently being used for a total.

The way to do this is to use the InScope function. I can control the background color of the total cell by putting the following code in the BackgroundColor property field.

=iif(InScope("group_Account"), "White", "Silver")

"group_Account" refers to the name of my Row Groups. It says, if this is visible in the current row, then change the formating.

HTH