SSRS Matrix row groups as actual rows

Question

I am not sure how to explain this, and I tried many different options, but I want it to be.

I want the row group of the matrix to appear as actual rows, and not as columns in the layout.

So, if I create a matrix with a group of resource columns and 2 groups of rows: a group of projects and a project name, these 2 should not be in separate columns. I just want to make the group in bold and the projects in the same column below.

This is just an example, my real problem is that when adding a large number of row groups the report becomes too wide.

How I would like:

         |  resource1  |  resource2  |  resource3
group1   |
project1 |
project2 |
group2   |
project3 |
project4 |

What is it now:

                    |  resource1  |  resource2  |  resource3
Group1  |  project1 |
        |  project2 |
Group2  |  project3 |
        |  project4 |

Answer 1

"". . . Dimension2DetailAkro - , Dimension1DetailAkro - "project":

http://3.bp.blogspot.com/_JVKkux5oAjM/Sifa2RBMKgI/AAAAAAAAJNo/Tf8jXkvbcio/s1600-h/GroupingExample.gif

,

Answer 2

.

() . .

(, ) , .

:

SELECT group data, GroupID + '1111' AS DummySorting
UNION ALL
SELECT project data, GroupID + ProjectID