How do I create a report that lists the RTC projects and the workers (contributors) for each project?
Tim McMackin's articles have been invaluable for getting us started using BIRT reports and showing how to do many of the things that one would commonly want to do with reports and RTC. That said, I have been struggling with how to create a report that shows all of the RTC projects and, under each project, shows a list of the workers (contributors) assigned to that project. The Live_Contributor_Assignment table seems to have the information that I need, but the only way to access information seems to be via the Contributor_ITEMID parameter. But, I need to get at the information from the project angle. Am I missing something? Has someone else been able to accomplish this?