Consolidate data from several lists in one view

Posted on 2011-04-27
Last Modified: 2012-05-11

Is there any function in SharePoint 2010 which enables me to consolidate the data from several tables into one? For example I have three diffent tables and all these tables contain inventory data for several users. Now I want to create a central view somehow in which you can see all the diffrent items which are being assigned to one user. Would that be possible somehow?

Thank you
Question by:Mc2102
    LVL 14

    Expert Comment

    That is doable . but will require some work.

    Can you send the Columns of all the three lists.

    Also those list must be on the same web .

    Author Comment


    There will be actually ore then three lists but here are three of them. I attached screenshots of the structure of the three lists called Desktops, Laptops and Phones.

    I would like to create a list or web part or view where you can see which devices have been assigned to a user. I actually would only need the name, type of device and asset no in one list.

    LVL 14

    Accepted Solution

    Here is the easy Solution

    [1] You will need a page where you can add those web parts .
    [2] Add the web parts {all your lists on the site page , either side by side or in a single column , that is your own layout}.
    [3] Add a SharePoint List filter webpart , { normally under Filter section}.
    [4] Add connection from the Filter Choice { on the Assigned to person} -> To the Assigend to on each of the other views. that will do it.

    If you are not familiar with this webpart I suggest you use it against a single list first and then use it against all three.

    I just finished a prototype here for your help.

    Best of luck.
    LVL 14

    Expert Comment

    Here is the expensive solution

    A bamboo webpart

    Forgot to list it on the previous post.

    Author Comment

    Hey Geoge,

    Thank you for your answer. I will check into it and see if I can figure it out.

    Thanks for sending me the link to the expensive solution but I prefer the cheap one.

    Thank you

    Author Closing Comment

    Worked like a champ

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now