Solved

How to see combined information from linked lists in SharePoint?

Posted on 2012-03-28
2
260 Views
Last Modified: 2012-04-19
Scenario: I have a list A with some items and list B with items linked to list A (for example number/currency values). Lists A and B have one to many relationship.

Problem: How to show combined values from the lists A and B

The only resolution I found that makes sense to me is import to Excel with PowerPivot and join lists there. Any other ideas?
0
Comment
Question by:MisUszatek
2 Comments
 
LVL 9

Assisted Solution

by:Tehzar
Tehzar earned 175 total points
ID: 37779284
0
 
LVL 7

Accepted Solution

by:
dhawalseth earned 175 total points
ID: 37781231
Hi,
You will have to use a dataview webpart with sharepoint designer, if you want to achieve this using OOB functionality.
If you are using MOSS2007, you will find a webpart by this name. And in Sharepoint 2010, insert and Empty List view webpart. Here are the links to few articles which will help you in creating the same.

http://www.codeproject.com/Articles/194252/How-to-Link-Two-Lists-and-Create-a-Combined-Ciew-i
http://melick-rajee.blogspot.in/2010/11/how-to-link-two-list-and-create-combine.html
(for advanced users)
http://office.microsoft.com/en-us/sharepoint-designer-help/display-data-from-multiple-sources-in-a-single-data-view-HA010099144.aspx
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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