Tuesday, March 20, 2012

Bold on Matrix subtotal

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.
Thanks!!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".
"anthonysjo" wrote:
> 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.
> Thanks!!|||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....
"Gavin R" wrote:
> 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".
> "anthonysjo" wrote:
> > 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.
> >
> > Thanks!!|||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
"anthonysjo" wrote:
> 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....
> "Gavin R" wrote:
> > 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".
> >
> > "anthonysjo" wrote:
> >
> > > 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.
> > >
> > > Thanks!!

No comments:

Post a Comment