I want to create a report that shows the number of workitems over time for different groups. I have already defined queries that give me the required results. They all have a filter on the AssignedTo field (for finding items assigned to a group of people) and a filter on the state field (to group states). All these trends should show up on the same chart.

How do I create a report that has different filters (AssignedTo and State fields) for each trendline on the chart ? Do I have to create a seperate dataset for each trendline ?

(I started from the "Work Item Trend" report in the TFS Report Examples (http://blogs.msdn.com/buckh/archive/2006/09/09/tfs_reporting.aspx)

Thanks

Hi,

Check out this msdn page about grouping data. i dont think you should need to create a separate data set for each line: http://msdn2.microsoft.com/en-us/library/ms155903.aspx

for more detailed questions report building questions, please try the Reporting Services forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

hope that helps. please let us know what you find.

thanks,

mauli