Last post Jul 13, 2011 03:43 AM by ravindra.patil
Jul 05, 2011 05:03 AM|naush83|LINK
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 Item28/3 Mark Task128/3 Mark Task228/3 Hank Task329/3 Mark Task229/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 Hank28/3 Task1 Task3 Task229/3 Task2 Task3 I've set up the matrix in the report but I only get the first item per day to show. Mark Hank28/3 Task1 Task329/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?
Jul 11, 2011 10:42 PM|You-Hu Fu|LINK
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
Jul 13, 2011 03:43 AM|ravindra.patil|LINK
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.