This question arrived this morning from Robert:
"Session 1 of your DVWP Series sounds like it might solve a problem we have. Namely, we need some way to display an aggregate list of all (printable) form documents at the top site level that includes in that list all (printable) form documents stored in document libraries of various subsites.
Question: How far would Session 1 address this need we have?"
There may be a couple of ways to accomplish what you need in your scenario, but the “List Relationships” is not one of them, unfortunately.
Here’s a blog post I’ve written about how to do a “roll up” web part
. Unfortunately, I haven’t ever been successful in working with document libraries with the roll up. I can get it to list all the documents, but haven’t been able to create the hyperlink to open each one.
Also, there’s a way you could create a linked source to merge multiple document libraries, but this wouldn’t be automatic, and you’d have to modify the data view web part each time a document library was added. Here’s a screencast that I’ve done on that concept:
Thanks for the inquiry!