Formatting Sub Totals in a Matrix

Would some one know how to control the formatting of Matrix Sub totals, such as Border around it, background color and font etc...I can't select the grey textbox that is rendered if sub totals are chosen from the context menu for a group.

Any help will be appreciated.

If you right-click on the green triangle in the corner of the subtotal label and click properties you should be able to access the properties of the subtotal text box (I believe it is actual labeled Subtotal by default).

Hope this helps,

Simone

|||I love this forum....Thanks!!!!!!

Formatting Problem

I would like to change the background of a cell if its value is 'Test'
I have tried this thru both custom code and just thru a simple iif statement both which produce errors. I put the following iif statemnt in

=iif(Fields!change_type.value="Test","Cyan","Red")

and get the following error:

c:\variset4\reports_microsoft\ToolPredByOp.rdl The background color expression for the textbox 'CHANGE_TYPE' refers to the field 'change_type'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

Any suggestions?disregard my last message - my line was correct - the problem was that Reporting services is Case sensitive. I should have had my field names in all caps. I found a good ei was trying to do at:

http://www.sqlservercentral.com/columnists/bknight/reportingservicesconditionalformatting.asp

if anyone is interested...|||

Hi.....

May be ur Prblm is Caps letter..or U Can also try Like this....
=iif(Fields!change_type.value="Test","Cyan","Red")
As
use ur Text Box Name instead of Field value.... ok write this Code in BackGround -- <Expression...>

=iif(ReportItems!textbox1.value="Test","Cyan","Red")

Best Regards......

format totals and subtotals on a matrix

i have a matrix with drill down, we have a divisional total, and a sub division total
i would like the background colour on the totals to be the same as the background colour on matrix columns ie division is blue and sub division is grey
--
Many thanks
JezThink of matrix subtotal cells as having two levels of style properties. The
first level deals with the cell that contains the default string "Total".
The second, or value cell, can be reached by clicking the green arrow in the
upper right corner of the Total cell. You will get the results you are
looking for if you set the background color of the group and the subtotal
value cell to the same color.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> i have a matrix with drill down, we have a divisional total, and a sub
division total
> i would like the background colour on the totals to be the same as the
background colour on matrix columns ie division is blue and sub division is
grey
> --
> Many thanks
> Jez|||this worked great thanks for the help, however implementing this has stopped my expression to colour negative figures RED
=IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
it still works on the main body of the matrix, but not the sub totals and totals
and ideas?
Many thanks
Jez
"Bruce Johnson [MSFT]" wrote:
> Think of matrix subtotal cells as having two levels of style properties. The
> first level deals with the cell that contains the default string "Total".
> The second, or value cell, can be reached by clicking the green arrow in the
> upper right corner of the Total cell. You will get the results you are
> looking for if you set the background color of the group and the subtotal
> value cell to the same color.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > i have a matrix with drill down, we have a divisional total, and a sub
> division total
> >
> > i would like the background colour on the totals to be the same as the
> background colour on matrix columns ie division is blue and sub division is
> grey
> > --
> > Many thanks
> >
> > Jez
>
>|||this worked fine, but it has stopped my expression to format negative figures RED
=IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
this still works in the matrix body but not the stub totals and totals
any ideas?
--
Many thanks
Jez
"Bruce Johnson [MSFT]" wrote:
> Think of matrix subtotal cells as having two levels of style properties. The
> first level deals with the cell that contains the default string "Total".
> The second, or value cell, can be reached by clicking the green arrow in the
> upper right corner of the Total cell. You will get the results you are
> looking for if you set the background color of the group and the subtotal
> value cell to the same color.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > i have a matrix with drill down, we have a divisional total, and a sub
> division total
> >
> > i would like the background colour on the totals to be the same as the
> background colour on matrix columns ie division is blue and sub division is
> grey
> > --
> > Many thanks
> >
> > Jez
>
>|||In testing, I've found that formatting the subtotal data cells by clicking the green arrow gives inconsistent results. Specifically, when I use this approach to format both column subtotals as well as row subtotals, I find that rows and column subtotals conflict - giving unpredictable results.
Instead, I read that one person suggested this approach - which worked well for me. Format the matrix data cell with something like:
=iif(InScope("Quarter"), "Transparent", "DarkGray")
Where "Quarter" refers to the group name. This is the only way I found I could get the background color of my subtotal rows and columns to appear the way I wanted.
Bruce Johnson [MSFT] pointed this out as a possible solution at http://sqljunkies.com/Newsgroups/microsoft.public.sqlserver.reportingsvcs/2004/6/30/281309.aspx, adding that such formatting should be more intuitive and he will pass his observations to the development team. In the meantime, however, at least we have an effective workaround.
"jez_UK" wrote:
> this worked fine, but it has stopped my expression to format negative figures RED
> =IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
> this still works in the matrix body but not the stub totals and totals
> any ideas?
> --
> Many thanks
> Jez
>
> "Bruce Johnson [MSFT]" wrote:
> > Think of matrix subtotal cells as having two levels of style properties. The
> > first level deals with the cell that contains the default string "Total".
> > The second, or value cell, can be reached by clicking the green arrow in the
> > upper right corner of the Total cell. You will get the results you are
> > looking for if you set the background color of the group and the subtotal
> > value cell to the same color.
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> > news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > > i have a matrix with drill down, we have a divisional total, and a sub
> > division total
> > >
> > > i would like the background colour on the totals to be the same as the
> > background colour on matrix columns ie division is blue and sub division is
> > grey
> > > --
> > > Many thanks
> > >
> > > Jez
> >
> >
> >|||Just a few comments, which probably explain the "unpredictable" results:
* style properties explicitly defined on the Subtotal element will always
win over styles defined on the _top-level_ reportitem in a matrix cell.
* If a horizontal subtotal intersects with a vertical subtotal and both of
them have explicit styles defined for the same style property, the
horizontal subtotal style will win.
* If the top-level reportitem in a matrix cell is e.g. a rectangle (which
could contain a textbox), only the rectangle's styles are overridden by the
subtotal styles. The styles of contained reportitems are not affected.
Consequently, you might have to consider the case where you use the InScope
approach but - for a particular style property - you have specified an
explicit value on the Subtotal, and the reportitem where you use InScope
expression is the top-level reportitem in a matrix cell.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mike Berenson" <Mike Berenson@.discussions.microsoft.com> wrote in message
news:BCC09120-A7E2-4858-AD98-948AFD1AB1E9@.microsoft.com...
> In testing, I've found that formatting the subtotal data cells by clicking
the green arrow gives inconsistent results. Specifically, when I use this
approach to format both column subtotals as well as row subtotals, I find
that rows and column subtotals conflict - giving unpredictable results.
> Instead, I read that one person suggested this approach - which worked
well for me. Format the matrix data cell with something like:
> =iif(InScope("Quarter"), "Transparent", "DarkGray")
> Where "Quarter" refers to the group name. This is the only way I found I
could get the background color of my subtotal rows and columns to appear the
way I wanted.
> Bruce Johnson [MSFT] pointed this out as a possible solution at
http://sqljunkies.com/Newsgroups/microsoft.public.sqlserver.reportingsvcs/2004/6/30/281309.aspx,
adding that such formatting should be more intuitive and he will pass his
observations to the development team. In the meantime, however, at least we
have an effective workaround.
> "jez_UK" wrote:
> > this worked fine, but it has stopped my expression to format negative
figures RED
> >
> > =IIF(Sum( Fields!Measures_Variance.Value )< 0,"Red", "Black")
> >
> > this still works in the matrix body but not the stub totals and totals
> >
> > any ideas?
> > --
> > Many thanks
> >
> > Jez
> >
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> > > Think of matrix subtotal cells as having two levels of style
properties. The
> > > first level deals with the cell that contains the default string
"Total".
> > > The second, or value cell, can be reached by clicking the green arrow
in the
> > > upper right corner of the Total cell. You will get the results you are
> > > looking for if you set the background color of the group and the
subtotal
> > > value cell to the same color.
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > >
> > > "jez_UK" <jezUK@.discussions.microsoft.com> wrote in message
> > > news:7C6A7CD1-0E5D-4200-8ADB-71F98ACFCD1A@.microsoft.com...
> > > > i have a matrix with drill down, we have a divisional total, and a
sub
> > > division total
> > > >
> > > > i would like the background colour on the totals to be the same as
the
> > > background colour on matrix columns ie division is blue and sub
division is
> > > grey
> > > > --
> > > > Many thanks
> > > >
> > > > Jez
> > >
> > >
> > >

Format Sub Total

If I want to change the background colko of a Sub total in a Matrix How do I
do that?
it does not allow me
thanksHi Carlos,
Thanks for your posting!
From your descriptions, I understood that you would like to change the
background color of subtotals. Have I understood you? Correct me if I was
wrong.
Here is Matrix subtotal cells has two levels of style properties. The first
level deals with the cell that contains the default string "Total". The
second, or value cell, can be reached by clicking the green arrow in the
upper right corner of the Total cell. You will get the results you are
looking for if you set the background color of the group and the subtotal
value cell to the same color.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

format codes - font colours, background etc

can anyone point me in the direction of help and assistance in formatting
using expressions?
an example would be change font to red if negative
also to change the background colour matix when using the visibility options
many thanksDid you read this section in BOL? Among many other examples it contains an
example for formatting values red when the value is negative.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_571v.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jez_uk" <nospam@.nospam.com> wrote in message
news:uwfdvy3ZEHA.3016@.tk2msftngp13.phx.gbl...
> can anyone point me in the direction of help and assistance in formatting
> using expressions?
> an example would be change font to red if negative
> also to change the background colour matix when using the visibility
options
> many thanks
>