Extend/collapse a matrix in ssrs 2008

Question

I am working on Microsoft Reporting Services 2008. There is a table I have like:

Name   Point
Alice  60
Mike   40

I want to arrange an extend/collapse on this table to make it like:

Name   Point
+Total  100

When I click +, I expect to see:

Name   Point
-Total  100
Alice   60
Mike    40

And clicking - will do the reverse. I see the post Extend(wide) or Narrow titles by listing them in SSRS 2008, it is so close to my question but it does not work for my situation since I cannot choose [Name] when I go to Name group and go visibility section as described there. I also do NOT want Total in another column like below:

-Total   Alice  60
         Mike   40 

I couldnt solve it on my own. If someone helps I would be grateful.

Answer 1

You don't need a group to set toggle functionality it can be used on any cell of your tablix.

Create a tablix with the following data arrangement.

Total is hardcoded, drag and drop the Name and Point fields to the cells on the details group.

Select the row and right click it, select Row Visibility... :

In the Row Visibility window select Hide and Display can be toggled by this report item: choose the textbox where Total was hardcoded.

In my case is Textbox 71.

Now preview your report, you will get something like this:

Let me know if this helps.