Have Geek Brain

Can I make a matrix series group for my child groups in SSRS?

I have a matrix whose rows are grouped into two groups. Class and time for this class. The class cell will end with multiple lines long, and I would like the lines for each class time slot to be next to the class description, for example:

-----------------------------------------
** Class ** | 7:00 am | [row data]
Description of | ----------------------
the class, this | 12:00 pm | [row data]
is several lines | ----------------------
long. | 1:00 pm | [row data]
-----------------------------------------

But I am getting the following:

-----------------------------------------
** Class ** | 7:00 am | [row data]
Description of | |
the class, this | |
is several lines | |
long. | |
-----------------------------------------
                  | 12:00 pm | [row data]
                  | |
                  | |
                  | |
                  | |
-----------------------------------------
                  | 1:00 pm | [row data]
                  | |
                  | |
                  | |
                  | |
-----------------------------------------

Is there a way to get SSRS to collapse the matrix?

+2


a source to share


1 answer


This is the solution I have come up with so far:

  • Create a list.
  • Add a data group to the list for the farthest row group (class in this example).
  • Populate the list with the contents of the outermost line (class and its long description).
  • Add matrix to list.
  • Populate the Matrix with the remaining groups (time and line data in this example).


The matrix will automatically map to the containing list, so each class will only display the time associated with it.

This leads to problems with headers (they are repeated with each iteration of the list). I am still trying to figure this part out.

+1


a source






More articles:


All Articles