I concur with SSC-Enthusiastic.
You'll only need to cross data sets if the two things you want to mesh are from different servers. Otherwise you can combine the two tables (even across databases) in a single T-SQL statement, and then use simple groups on the table to display it how you want.
2008R2 lets you do limited lookups, and another poster mentioned code-behind, but I consider such trickery to be beyond most mere mortals and usually more trouble than they're worth
PS: I don't usually resort to violence but the world would be a better place with one less scab in particular from this thread leaving alive.