How to Create a SharePoint Data View Web Part “Rollup” (Screencast)
Author: Laura Rogers, Birmingham, AL
SharePoint 911
A common topic that is asked about in SharePoint, is how to roll up information from sub-sites to a top level site, and just generally how to show data from one site on another site. There are different methods and 3rd party tools that can be used, but here is a simple way to create a roll-up, that you can do yourself, using the data view web part, and a tiny bit of code. I’m not a developer, I swear! In this 5 minute screencast, I’ll show you the fundamentals behind creating your own rollup. This screencast is based on my recent blog post. http://sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?ID=46, which is where you can read more information, and get more details on how it’s done.
Author: Laura Rogers, Birmingham, AL
SharePoint 911
- New Article Series: Laura Rogers on Data View Web Part Basics
- Data View Web Part, The Basics - Insert a DVWP on Your Page
- 6 Minute Screencast: Insert a Data View Web Part onto a SharePoint Page
- Data View Web Part, The Basics - Folders
- 3 Minute Screencast: Use DVWP to display all files, even those stored in folders!
- Data View Web Part, The Basics - Add a Hyperlink
- Data View Web Part, The Basics - Keep it Clean
- Data View Web Part, The Basics – Multiple Edit Forms
- 3 Minute Screencast: Data View Web Part, The Basics – Multiple Edit Forms
- Live Online Workshop - Data View Web Part Solutions: Part 2
- 5 Minute Screencast: SharePoint Web Services for Non-Developers
- 3 Minute Screencast: Merging SharePoint Document Libraries
- 2 Minute Screencast: Permissions Dashboard
- 4 Minute Screencast: Join View of SharePoint Lists
- Get it Together: Groups and Totals in the Data View Web Part (Screencast)
- SharePoint: Open Links in a New Browser Window (Screencast)
- How to Create a SharePoint Data View Web Part “Rollup” (Screencast)
- SharePoint: "New" Icon (Screencast)
- Display a SharePoint List on Another Site (Screencast)
- Customize the "no items" Display Text in SharePoint (Screencast)
- SharePoint: Displaying Calculated Column SUMS in a View (Screencast)
Laura,
Great solution and overview on how to do this. This will be very helpful for future projects.
Laura,
You are the ‘Queen’ of SPD. This looks great and I can use this on some of our department sites. Like to see how it would work using calendars.
I am rendering articles from three publishing sub sites together into one DataView Web Part thru linked resources. All three sub sites have different security.
If user logs in with access to all three sub sites it works fine. But if user doesnt have access to any one of them, it throws following error:
“Access denied. You do not have permission to perform this action or access this resource.
I dont know if i done something wrong in the web part configuration in SP Designer or DataView is not able to handle security trimiing ? is there any way i can render security trimming thru DataView Web Part.
Any help will be much appreciated.
Thanks in advance.
Great collection of videos!!!
Thanks
Great screencast again Laura! Thanks.
This would serve very well in our site but unfortunately I get a “The server returned a non-specific error when trying to get the data source. Check the format and content of your query and try again.” error. Went through your steps one by and made sure I was doing exactly the same things. Slightly frustrating.
Excellent! Thank you.
This is extremely helpful and relevant, Laura. Whatever you post is gold!
Hi Laura
I want to do something like this, but just a little different.
On my top level site, I will add in all quotes by all customers.
I have created another site which is called a customer site. What I want to be able to do is show the data from the main quote log on the customer site, but only the quotes that belong to that specific customer.
Can this be done?
Iain
Hi Laura and thanks for these articles. I have managed to get your roll-up solution working but have the following observation: Despite creating a custom content type for use with my custom list, the roll-up includes items from all content types inthe site collection UNLESS the data query within the “current data source” includes a column which is unique to the list I am rolling up. This suggests to me that the roll-up process included all lists, regardles of their content type(s), thank contain all the columns specified in the data query. So, for instance, if I only include the title in the datasource query (and obviously the DVWP) I get everything from the site collection which has a “Title” column in it.
I hope this makes sense? Am I doing something wrong. I hve been struggling with this for a couple of weeks now and still don’t feel I understand what is happening.
Many thanks
Tim
Dear Laura:
I followed your instructions to the letter, but when I click in the Design surface after inserting , I lose the Cost Category groupings and the Purchasing Cost currency values. What I’m left with is simply the titles of all the Purchasing items from the various Purchasing lists in my site collection. Do you know why this happens? Up until this point, I can replicate everything you are doing in the tutorial.
Thanks,
Darren.
Hi Laura
I just wanted to say a big thank you. This has worked fantastically for me, I’m using it in a slightly different way but excellent all the same.