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

You're nearly there. You've correctly identified that you don't want '=First(...)'; I'd suggest something like '=Join(Field!TaskName.Value," ")'. Alternatively, you could do something similar in the SQL query. RayIf this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find a solution more easily.

Hi Rapier, Thanks for your reply. But I couldn't do it with Join. Well, I didn't get the logic of using Join. In my case, I need to display multiple cells separately, instead of concatenating those multiple cell's data and displaying in a single cell. It should be look like :- Mark Hank 28/3 Task1 Task3 Task2 29/3 Task2 Task3 Please enlighten me. Thanks, Naush

I think it's more complicated than doing the Join, but you could probably nest a list within 'data' part of the matrix: Drag a list item into the data cell in your matrix. Drop the Work Item into one of the columns of the list and delete other columns and the header row. Apply a filter to the list by Date and Person and link these to the row and column groupings of the matrix. I did say it was more complicated! Thinking about it though, it should look better this way. Also remeber to make shure you have the 'Can Grow' property of the cell set to 'True'; it should be by default but it's always worth checking.If this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find a solution more easily.

I think it's more complicated than doing the Join, but you could probably nest a list within 'data' part of the matrix: Drag a list item into the data cell in your matrix. Drop the Work Item into one of the columns of the list and delete other columns and the header row. Apply a filter to the list by Date and Person and link these to the row and column groupings of the matrix. I did say it was more complicated! Thinking about it though, it should look better this way. Also remeber to make sure you have the 'Can Grow' property of the cell set to 'True'; it should be by default but it's always worth checking. If this post, or another, answers your question, please click the 'Mark as answer' button so others with the same problem can find a solution more easily.