How to manage multiple results per cell in reporting service matrix?

Question

User830154249 posted

I need to have report using matrix that displays:

- weekdays on the x-axis

- persons on the y-axis

- and the assigned workitems in the cell.

 

This works fine if there's only one work item per day but some work items are shorter and thus the resource is assigned more than one a day. My dataset may return something like this:

 

Date    Person    Work Item

28/3    Mark      Task1

28/3    Mark      Task2

28/3    Hank      Task3

29/3    Mark      Task2

29/3    Hank      Task3

 

 

In this case I'd like the matrix to look something like this, i.e. the two tasks Task1 and Task2 in the same cell:

        Mark      Hank

28/3    Task1     Task3

        Task2

29/3    Task2     Task3

 

I've set up the matrix in the report but I only get the first item per day to show.

        Mark      Hank

28/3    Task1     Task3

29/3    Task2     Task3

 

The default definition in the cell was "=First(Field!TaskName.Value)", so I figured I'd solved the issue by changing it to "=Field!TaskName.Value", but it didn't.     

 Can anyone help me?

Thanks,

Naush

Answer 1

User1471008070 posted

Hi,

To this scenario of yours, I would recommend you make use of Table to achieve this requirement, person as column group, Date as row group, Work Item as detail row's group (make sure you give Work Item as group to detail rows) Then I think you can get what you need.

Answer 2

User1426937062 posted

I have done this by usnig matrix. You can do this by following way.

Take a matrix to display the  

1. weekdays on the x-axis (Row Group) and

2. persons on the y-axis (Column group),

But while displaying the assigned workitems in cell you need to place the table inside the matrix cell. (One table in one cell, Table will have only one cell and value will be the assigned workitems). Do some formatting as you want and get the expected result.

Hope this will help you.