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

  • 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
    Tuesday, July 5, 2011 5:03 AM

Answers

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 11, 2011 10:42 PM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 13, 2011 3:43 AM

All replies

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 11, 2011 10:42 PM
  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 13, 2011 3:43 AM