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

Blank sub report:

Hi, I have a report which has a subtotal and users can click on the
subtotal and go to a sub report.
However, when people click on the subtotal they are shown a blank
screen (Apart from the standard reporting services header). When I
right-click on the blank screen and view the properties of the report
I get the following
http://webserver/ReportServer?rs:Command=Blank
I have triple checked all the stored procedures, parameters etc. The
*exact* same code runs fine on our development server and I can view
the report via the Visual Studio 2003 IDE no problems at all.
Any ideas welcomed!
Thanks
MarkusOn Apr 26, 5:46 pm, Markus...@.gmail.com wrote:
> Hi, I have a report which has a subtotal and users can click on the
> subtotal and go to a sub report.
> However, when people click on the subtotal they are shown a blank
> screen (Apart from the standard reporting services header). When I
> right-click on the blank screen and view the properties of the report
> I get the following
> http://webserver/ReportServer?rs:Command=Blank
> I have triple checked all the stored procedures, parameters etc. The
> *exact* same code runs fine on our development server and I can view
> the report via the Visual Studio 2003 IDE no problems at all.
> Any ideas welcomed!
> Thanks
> Markus
This might sound trivial, but are both the report and the subreport
physically located in the same directory on the Report Server? Also,
is the subreport's datasource set correctly on the Report Server?
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 27, 12:52 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Apr 26, 5:46 pm, Markus...@.gmail.com wrote:
>
>
> > Hi, I have a report which has a subtotal and users can click on the
> > subtotal and go to a sub report.
> > However, when people click on the subtotal they are shown a blank
> > screen (Apart from the standard reporting services header). When I
> > right-click on the blank screen and view the properties of the report
> > I get the following
> >http://webserver/ReportServer?rs:Command=Blank
> > I have triple checked all the stored procedures, parameters etc. The
> > *exact* same code runs fine on our development server and I can view
> > the report via the Visual Studio 2003 IDE no problems at all.
> > Any ideas welcomed!
> > Thanks
> > Markus
> This might sound trivial, but are both the report and the subreport
> physically located in the same directory on the Report Server? Also,
> is the subreport's datasource set correctly on the Report Server?
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Hi, yes, both the reports are in the same directory and they are both
using the same datasource.
The parent report is called rptShowAllIncome and the associated child
report is called rptShowIncomeDaily (In case there is some problem
with naming conventions or something else I should know about).
In the parent rerport I am grouping by business and I have created a
link through to the child report on the following field
=Sum(Fields!TotalEarnedMonth.Value)
and I am passing through two parameters to the child report (The child
report is populated by a stored procedure which takes three parameters
but the third one is nullable so I am not specifying anything for this
paramater). I have tried specifying a value for the nullable parameter
but it still did not work.
Again, like I said I get no errors just a blank screen with
http://webserver/ReportServer?rs:Command=Blank
Thanks for any/ all help
Cheers
Markus