Groups | Blog | Home
all groups > sql server reporting services > march 2006 >

sql server reporting services : Bold on Matrix subtotal


anthonysjo
3/2/2006 8:45:15 PM
Hello all,

Does anyone know how to make a subtotal column on a matrix report bold? I
can bold all data but can't seem to figure out how to only do the subtotal
column.

Gavin R
3/3/2006 2:50:03 AM
Hi,

Matrix subtotal properties can be set by clicking on the green triangle in
the upper right corner of the "subtotal" text box. You could also right-click
on this triangle and select "properties".

[quoted text, click to view]
anthonysjo
3/6/2006 7:45:29 PM
When I do this it just bolds the header not the data. The only way I can get
the data in that column bolded it to bold it all.....

[quoted text, click to view]
holan
4/12/2006 12:45:02 AM
Use InScope()

eg: in the Text-Field for the Value goto Properties-Font-FontWeight
use something like =IIF(InScope("RowGroupName") AND InScope("ColGroupName"),
"Normal", "Bold")
This will format all Subtotals (Multiple Groups, Row-Subtotals and
Col-Subtotals) to Bold.
If you need more control use multiple IIFs.
Read the Help for InScope.
And search this Forum for InScope for more hints.


--
LG HOLAN


[quoted text, click to view]
AddThis Social Bookmark Button