.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Melody Anderson
Post New Web Links

Cannot properly join lists in SPD 2007

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

Ok, I have been reading all sorts of posts and such for about a week and still have no come up with any concrete answers.


I cannot properly join lists in SP 07. I say properly because I never get the option to select a field to associate one with the other. 

I select "Create new linked data source" from Data Source Library; Pane opens; Left Click "Configure Linked Data Source"; Add 4 to 5 lists from "Current Site"; Select Next; Select Join option but Next is greyed out. Is this supposed to be greyed out because they are lists? Can lists be joined? I see alot of examples on joining databases and excel pages but not too many on lists.

If I select next from the last point, open the linked sources and select my newly created linked source and click to show data, I can see all of the information in there. Problem is I don't believe the lists are really joined by anything since I never received an option for it. 

I also have been reading up on joined subviews but I never receive an option for  joined subview. Is the joined subview the way to go for lists? If so how?


I know these boards are fairly active and any information or help would be greatly appreciated.

View Complete Post

More Related Resource Links

Discussion board template of SharePoint 2007 not working properly


Use case 1 – Discussion board to suggest change to documents

 User adds a suggestion. The discussion board needs fields like module name, document name, section name and reason for a change etc.


 Problem 1 – When I try to add fields to the discussion board – When a user wants to post a reply to a suggestion, user screen shows the new item form and all fields instead of just a reply or comment field. Need help how can I ensue user only sees reply or comment field?


 Problem 2 – If I make these changes in the discussion board template through SharePoint designer 2007 and later if we plan to upgrade to SP 2010. Do I have to redo the changes I did on old discussion board or will upgrade take care of migration of the changes to new discussion board template available with SP 2010? 




Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Cross list query for two sharepoint lists and a join between the fields

Hello All, I have a requirement where i need to query the data from two  sharepoint lists  on a same site by doing a join between those lists and get the result into datatable.I am doing this using sharepoint object model.Is there any possibility to do this. Any pointers in the right direction are greatly appreciated. Thank you Smith   smith

how to Join two SharePoint Lists in SharePoint 2010

I have one Document Library and One List, just want display data from both based on ID in SharePoint 2010. Document Library : "Doc1" having following columns 1. ID (default column) 2. Title 3. Description 4. Image Url List : "List1" having following columns 1. RefID ( lookup column, refers the doc1 ID column) 2. Created By I want to display get data table for what are the ID's(items) created by me using CAML Query (SPQuery.Joins)  

Join two Lists/Library in SharePoint 2010

I have one Document Library and One List, just want display data from both based on ID in SharePoint 2010. Document Library : "Doc1" having following columns 1. ID (default column) 2. Title 3. Description 4. Image Url List : "List1" having following columns 1. RefID ( lookup column, refers the doc1 ID column) 2. Created By I want to display get data table for what are the ID's(items) created by me using CAML Query (SPQuery.Joins) Pls give me solution... Thanks in adv...

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Join Expression Not SHi All, I use Access 2007, and I have the following SQL problem: I have two t

Hi All,

I use Access 2007, and I have the following SQL problem:

I have two tables TransformerTypePeriodBOMProducts and TransformerTypePeriodProducts. The first table has 4 fields: TransformerTypeID, OutputProductID, PeriodID and BOM, while the second has the following 4 fields: TransformerTypeID, OutputProductID,PeriodID and AssemblyCapacity. So as you can see, there are 3 fields (TransformerTypeID, OutputProductID and PeriodID) that are in both tables.

I need to delete all records in the first table that have the field AssemblyCapacity in the second table equal to 0 (and of course have similar TransformerTypeID, OutputProductID and PeriodID fields).

I tried many trials, the last I got was:

SELECT TransformerTypeAssemblyPeriodBOMProducts.*
FROM ((TransformerTypeAssemblyPeriodBOMProducts INNER JOIN TransformerTypeAssemblyPeriodProducts ON TransformerTypeAssemblyPeriodBOMProducts.TransformerTypeID=TransformerTypeAssemb
lyPeriodProducts.TransformerTypeID) INNER JOIN TransformerTypeAssemblyPeriodProducts ON TransformerTypeAssemblyPeriodBOMProducts.OutputProductID=TransformerTypeAssembly
PeriodProducts.OutputProductID) INNER JOIN TransformerTypeAssemblyPeriodProducts ON TransformerTypeAssemblyPeriodBOMProducts .PeriodID=TransformerTypeAssemblyPeriodProducts.PeriodID
DELETE * FROM TransformerTypeAssemblyPeriodB

Audit logs on 2007 - specific items that have been viewed in lists


Hi all

I'm far from being an expert in SP, so please would you treat me like you're responding to your granny ;-)  I'm a basic user, who has set up a team site (one of thousands) within a coropration.

I've created a 'list' to use to post briefings.  I now want to track who has clicked on the briefing to read it, and when they did that.  I've tried creating a custom audit log, and that tells me they visited the list, and that they clicked into an item, just not which specific item in the list.

The 'document location' tells me the visited 'sites/Trainingdelivery/Lists/General message/DispForm.aspx' but the URL to a specific item looks like this 'sites/Trainingdelivery/Lists/General%20message/DispForm.aspx?ID=207'. 

How do I capture the specific ID?

Or, is there a way to add something into my list to get users to click to say they've read the message?  my problems with this so far, is I target messages at groups, not individuals, so each item in the list could not be edited to say read, as they would update it for everyone in the group, not just the individual.

Thanks in advance for your help!

Compare/Join two lists and return results


I have a request to take two lists with similiar data, combine the data and display the results set differences.

List A:Serial:Hub

List B:Serial:Location

As an example I need to take and map the hub in list A (Lets say "Chicago") to the Location in List B (lets say "DEST.Chi") and find matching and missing serial numbers. There are 10 hubs and 10 locations that map to each other. Both lists are in the same site. Could someone point me in the right direction?




Fix it until it breaks!

MOSS 2007 - Propagate changes to multiple sites and lists

We use MOSS 2007 for doc mngmt and maintain individual sites containing lists and libraries for each of our 90+ projects.  All sites are created from a site template and we wish to keep them all identical.  How should I push out changes and updates as business requirements change?  In other words, if we change/update the template, how can I make all the sites and lists look the same?

Wiki lists in MOSS 2007 HTML Validator bug


HI all,

I'm facing a nasty problem with Wiki lists in MOSS 2007. I managed to create a custom functionality for the Wiki list which allows our users to insert business images into the Wiki page. So actually I programmed the functionality to insert inline images (base64 encoded) into the SharePoint HTML editor. So far so good but on server side when the list item is saved, it seems there is some kind of HTML validator or something which removes the entire "src" attribute probably because it's value is not an URL but something like ""data:image/Png;base64, here goes base64 string of the image". Also some custom attributes for HTML elements are removed during this interesting validation/filtering...So if I have some custom attribute for an "img" html element, the attribute is removed on server side when the item is saved.

This strange behavioral is only for wiki lists but if I have a custom list with the MultiLineText field (with rich text mode enabled) my base64 src for images are not removed.

Does anyone have any idea how can I disable that server validator/filter? I even checked with reflector but couldn't find any helpful information.

In my opinion this is a SharePoint bug since base64 inline images are supported by IE8...


Join MOSS 2007 to exsiting Fram but used own database


Dear All

  Our Company have  MOSS 2007 Server fram, I need to create new MOSS 2007 for used only our team, I need this server join to exsiting fram, I install SQL 2005 on this server, I need to keep all data on this NEW MOSS server kepp on local Database, Please tell me about step that I will complete job


Thank you for your support

Join Sharepoint lists with SRS.


I'm trying to join two lists in a report.  The dataset creator will not let you choose more than one list. 

I've gone through the FAQ on the site.  It doesn't give any mention of SP Lists.  I'm guessing I'll have to find a way to join multiple datasets.

David Jenkins

Displaying SharePoint lists in Web Parts

When you create a built-in or custom list in Microsoft Windows SharePoint Services, Windows SharePoint Services creates a Web Part, a basic building block of a SharePoint site, to display that list. These Web Parts are called List View Web Parts. Windows SharePoint Services stores List View Web Parts in the site collection Web Part gallery. (The site collection Web Part gallery is the most central gallery of Web Parts for a work group. By default, the gallery name is the name of the site, such as "Our Team Site Web Part Gallery." )

SharePoint Tutorial - Lists

A list is a feature in SharePoint that stores a lists of information. For example, a list can be created to store web links in the human resources team site. A list is usually created for a specific type of information. Lists can contain metadata to describe the particular information in more detail and to make it easier to find.

MOSS 2007 Tutorials video

This link about how create sharepoint website ,blogs,team site,document lib etc

Write Custom WebParts for SharePoint 2007

The popularity of SharePoint Portal Server 2003 led Microsoft to tightly integrate the next SharePoint version, Microsoft Office SharePoint Server (MOSS) 2007, with its ASP.NET 2.0 WebPart framework. This tight integration enables the ASP.NET and SharePoint developer to do a number of things that previously weren't possible
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend