SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a site collection containing sites with the same list template called Tasks. I want to aggregate all the active tasks and display them at the top level site. I think the XSLT List View Web Part (XLV) is the solution because I'm not an expert at XSLT so I don't want to use a CQWP and apply XSLT if possible. I believe that was the solution in SP 2007, but the new web part in SP 2010 is supposed to make it easier.

share|improve this question

This article by Waldek Mastykarz describes how you could achieve that with Content Query Web Part. It's seems to be perfect for your scenario.

In case you do not want to use Content Query Web Part, the alternative is to use Data View Web Part, check how you can Add a linked data source and Display data from multiple datasources.

share|improve this answer
Close but not quite. CQWP only brings back Title. I want more columns than that. I believe CQWP requires some XSL work to add columns. I don't want to do that. I thought XLV web part provides administrative options to add columns without writing code. The user task web part only shows open tasks for "current" user. I want all users. Thanks. – XLVNewbie Nov 29 '10 at 1:22
Made some changes, hope these will help. There is no wizard that will allow you to do this from UI, you need to use some XSLT or HTML to get it to work. For wizards you will have to use 3rd party tools like: – Toni Frankola Nov 29 '10 at 10:46

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.