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.
Excellent post - I've looked high and low for the solution to this problem!
Cheers
Pete
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.
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
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