Solved

How to see combined information from linked lists in SharePoint?

Posted on 2012-03-28
2
263 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
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 …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 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