Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is there any possibility to join Sharepoint 2010 internal data sources (like lists) in "out-of-the-box" Sharepoint 2010 tools or SPD without using programming tools?

"Join" and "merge" queries exist creating "Linked Data Source" (by "Link Data Source Wizard") but when I try to use it for lists and go yo "Query" tab, all options are disabled and it is written there:

  • "Query options are availablefor Database Connections only"

Why?
And if it is impossible to configure joins, then why does it permit to add lists to a linked Data Source?
And what does it mean?

Should I prefer external data sources over internal ones?
Why cannot list joins and merges be configured?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

You can absolutely create joined views, but there's no way to do what you would think of as a real "join". What you end up with, even if you just add a Joined Subview with the ribbon options, is a sort of filtering of the items in the second list based on the current value of a column (or columns) in the first list.

I create DVWPs all the time with two or more DataSources in an AggregateDataSource which allow me to build complex and sophisticated displays by customing the XSL. I have lots of posts on my blog that show you various possibilities. http://sympmarc.com

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.