Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SharePoint foundation summarizing lists into a report

Posted on 2013-01-22
7
Medium Priority
?
195 Views
Last Modified: 2013-01-25
No backstory, today; just a noob not getting it done...

Have two sharepoint lists; one has miles and another has miles closed (there are more columns, but they're all roughly the same chore.)

How to create a summary report list that uses specific column (in this case list "A" has a work order column and list "B" is a lookup column from list "A" for work order.

So how to simply create a summary report of miles and miles closed that line up in rows based on the "key" column work order.

I've seen the content query web part notes; many speak about document libraries and frankly the thing is numbing for the noob.

Ready, when you are...
0
Comment
Question by:VirtualKansas
[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
  • 4
  • 3
7 Comments
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 1500 total points
ID: 38808149
here is a short video showing you exactly how to do what you are looking to do
http://www.screencast.com/t/DwN6aAeRLBC
0
 

Author Comment

by:VirtualKansas
ID: 38812992
Good video; doesn't quite answer the question in a way that explains setting multiple site data sources.  Is there a more  direct answer available?
0
 

Author Comment

by:VirtualKansas
ID: 38812997
Issue with video doesn't quite get the beginning of the web part choices and data source establishing.  If I Gould those things in a prequel; the rest looks spot on?..
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 15

Expert Comment

by:sharepointguru14
ID: 38817354
I'm not sure what you mean. What part don't you understand how to setup? Vendor is your work order column.
0
 

Author Comment

by:VirtualKansas
ID: 38818485
OK; trying not to be a flake about an dthnaks for shooting another note.  A little backstroy; I've been around SharePoint a long time, but only basic functionality use, mainly with document storage.  I've of course done some basic lists, but never really used designer.

So the rut I'm in is creating a basic web part page, with the "correct" web part and data connection to follow the vidoe instructions.  I can follow along well enough, but designer is confounding (eluding) me just enough to fail.

Again; its definetly me, the video is great.  Juts have list "A" and list "B" and need a list "C" that has a "key" column to return some data from list "A" and ";ist "B" in rows tied to key column.  What web part (sounds dumeb even typing) and how to acquire list A and list B as data sources for the joined function of adding the data fields? Make any more sense?
0
 

Author Closing Comment

by:VirtualKansas
ID: 38820557
One word "Bamboo".  Out of the box List Roll Up Web Part got me there on foundation in minutes.  Then discovered all the things they have; cuts dev. time down to nil.  Points awarded for patience with noob and the video really was well developed.  TY
0
 
LVL 15

Expert Comment

by:sharepointguru14
ID: 38821384
Well if you said 3rd party solutions that cost money were an options yes bamboo or amrein would help out greatly!

but to try and clarify where you are lost. I think you were looking to create a 3rd list to join A and B together. But really you would be putting a Dataview "webpart" in designer and showing results from list A and B as 1 list. There wouldn't actually be a 3rd list anywhere.

Glad you found bamboo they have some good stuff. Amrein engineering also has some nice webparts that can help out and cut dev time down drastically and they are rather inexpensive too.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

636 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