MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SPD: joined or nested data in DataView

  Asked By: Kenya    Date: Jun 02    Category: MOSS    Views: 2613

This seems like it should be simple, but perhaps the inherent simplicity of
SharePoint Designer makes it a bit more complex.

I have two lists that I want to link and display in a relational
(parent/child) format. I thought first that maybe I could just create a
Linked Source and it would somehow join the two lists for me, but there
seems to be no way to assign a join field (in which case it's not really a
join at all, so I don't see the point). All I get is List 1 on one side and
List 2 on the other side, which again makes no sense from a "join" point of

I've fiddled with the XSLT but there doesn't seem to be a way to do this.
Does anyone have a suggestion as to how to get the data to nest, or at least
to be truly joined? I read Boris Gomiunik's post on nested data, but he
seems to be dealing with a single list that he wants to display in a "group
by" fashion.



6 Answers Found

Answer #1    Answered By: Kelsie Terrell     Answered On: Jun 02

One possible option is to use the RSS feed from a customized Content
Query Web Part as the data  source. It requires MOSS and some XSL kung
fu to make sure you are emitting all the columns you want, but it is
technically possible.

Answer #2    Answered By: Alka Sarabhai     Answered On: Jun 02

Another would be to use a DVWP feature that is a little bit  hidden ;-).
(The following is from the top of my head, so the labels are probably slightly
Once you have your linked data  source, click the columns you want to insert from
parent list.
Insert as multiple view.
Click on one TR in the dvwp and either use insert additional TD or TR (depends
on how you would like the final result rendered).
Click into the newly created TD|TR, choose some columns from the second list  and
insert as "Joined sub-view".
SDP will now let you choose the join  field that you want to use.

Answer #3    Answered By: Eashan Nadkarni     Answered On: Jun 02

but when I right-click the extra data, I don't see anything
that remotely resembles "joined" or "sub view". All I get are "Insert as
Text [or Label, or Date/Time]", "Insert as Indexed Value", "Copy Item
XPath", and a few others that look similar.

I tried doing this with an un-linked list, but nothing came of that either.
Any other suggestions?

Answer #4    Answered By: William Odom     Answered On: Jun 02

I just found "Joined Subview" on the "Insert Selected Fields as..."

Maybe I should take a nap now.

Answer #5    Answered By: Mia Scott     Answered On: Jun 02

After you configure the Linked Data Source, you can use the DVWP to
join the two list. It is a bit  involved, but possible. After adding
the DVWP to an aspx page, you would identify your various columns to
add to the page. Next, next the additional columns from the second
list. That is how you identify the column that establishes the join
relationship. It has to be done on the aspx page by selectively
adding the columns from both lists.

if you need a step by step, post  your question on the board. It will
take me a few days, but we can get it done.

Answer #6    Answered By: Kristian Chaney     Answered On: Jun 02

I may take you up on that offer if I can't get this going.
Odd that there seemed to be no way in that process to assign  a join  field.

Didn't find what you were looking for? Find more on SPD: joined or nested data in DataView Or get search suggestion and latest updates.