Multiple results per cell in reporting service matrix?
My team is using TFS for work item management and I'd like to provide a week schedulematrix 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 WIT (work item)per day but some WIT's are shorter and thus the resource is assigned more than one a day. My dataset may return something like this: Date Person WIT 28/3MarkTask1 28/3 MarkTask2 28/3HankTask3 29/3 MarkTask2 29/3HankTask3 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: MarkHank 28/3 Task1Task3 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. MarkHank 28/3 Task1Task3 29/3 Task2 Task3 The defaultdefinition in the cell was "=First(Field!TaskName.Value)", so I figured I'd solved the issue bychanging it to"=Field!TaskName.Value", but it didn't. ...any idas??
March 20th, 2008 7:01pm

Hey Mats, I'm not sure how to do this - I'm moving your thread to the SQL Reporting Services forum - they are the experts here. Good luck, mauli
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2008 1:12am

Hi Mats, Did you find any solution for the problem of multiple resources per cell in matrix that you posted above? I am also facing the same issue and please share it if you could find a workaround. Thanks, Naush
July 3rd, 2011 7:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics