As soon as you want to make the subtotals in a matrix bold or give them a different colour, you will notice that this does not work well. You cannot just make the word “Total” bold but will have to take one extra step. Read here how to quickly change the formatting of your subtotal row with this simple step.
{highslide type=“img” url=“artikelen/ssrs/totals_bold/ssrs_subtotal_bold_01.jpg” width=400 captionText=‘Subtotals bold’}{/highslide}
The trick is to right-click the green triangle in the subtotal cell and then choose properties. You now see the properties and can change them, for example make them bold.
{highslide type=“img” url=“artikelen/ssrs/totals_bold/ssrs_subtotal_bold_02.jpg” width=400 captionText=‘Subtotals bold’}{/highslide}
Frequently asked questions
How do I make a subtotal bold in an SSRS matrix?
Right-click the green triangle in the subtotal cell and choose properties. Change the formatting there, for example bold.
Why can't I make the word Total bold in an SSRS matrix?
The formatting of the subtotal row works differently. You have to take an extra step: open the properties of the subtotal cell through the green triangle.
How do I change the colour of a subtotal in an SSRS matrix?
The same way as bold. Right-click the green triangle in the subtotal cell, choose properties and change the formatting there.
What is the green triangle in an SSRS matrix?
It is in the subtotal cell. Right-click it and choose properties to change the formatting of the subtotal row.
Can I change the formatting of the subtotal row in an SSRS matrix?
Yes. Open the properties through the green triangle in the subtotal cell. There you can change the formatting, for example bold or a different colour.
Comments
Related blogs
SSRS Best Practice I - Limit datasets
How do I back up my SSRS report as RDL
Backing up Reporting Services Data