Hi Experts,I have sharepoint site as a top level and under this we have n number of subsites. Each subsite has a custom list and that data is displayed on gant chart. Now reqrirement is how to show these custom lists on the home page.More clear by this : There’s a list on left called ABC. It contains a list and a Gant chart. The same list will appear on the other subsites like A, B, C..etc. The user wants to know how to have a list and Gant chart on the Home Page that contains the list data for all the subsites. The subsite list will show the data from the home page, but the data will be filtered on the BU. A Gant chart is also needed.Any help will be highly appreciated.Ram Sharma

Hi there, As I understand this, you want to roll up information from various lists in subsites into one list on a home page, and the view is to be filtered, and a Gantt chart displayed? Well, I think that out of the box this isn't possible, simply because you want combine the data from the lists into one list (for a start). For example, you could have used a Content Query Web Part to get to the list data; even to filter it, but this is single hit and does not allow you to expose the data as a Gannt view. Meaning that you would have to expose a Content Query Web Part for each list in each subsite on the home page (not one single list). The only other option would be to go down the third party route and use something like Quest Web Parts available here , or like Bamboo List Rollup Web Part available here . Hope this helps Cheers Geoff

Hey Geoff,Thank you. yes this is not possible by out of the box features of sharepoint.If I start this by creating custom webpart, can you pleas tell me the possible start up ways,I mean the logic behind this.Thanks again.Ram Sharma

Hi there, I suppose the best starting point would be to try create a data view and connect the lists from there... Displaying SharePoint lists in Web Parts: http://office.microsoft.com/en-us/sharepointtechnology/HA011265571033.aspx Connect two Data Views: http://office.microsoft.com/en-us/sharepointdesigner/HA101691331033.aspx And some screencasts are here: http://www.endusersharepoint.com/2009/11/13/how-to-create-a-sharepoint-data-view-web-part-%E2%80%9Crollup%E2%80%9D-screencast/ Hope this helps Cheers Geoff

Hey Geoff,Seams it'll work out, great help brother, thank you.CheersRam Sharma

RamWere you able to get this to work. I also need to have child Gantts lists roll up to a parent Gantt. I have been able to roll up the data using the Data View but can not get a Gantt to work. Any suggestions would be appreciated. Mark Kwiatek

Hi Mark, Yes, it is done for me. Do you need this then please tell me?Ram Sharma

Hi Ram I am looking to use something similar. Is it possible to send details to me? many thanks Allan Bury