SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got two lists. I've created a dataview webpart and have created a joined subview. The data that is presented is correct. In the below example, there would be a match for all items with the exception of Item 3. It would display like the following:

Item 1 United States
Item 2 Canada
Item 3 No Item Exists ...
Item 4 Mexico

My current list has more than 800 items. What I would like to do is create a filter that only would show me:

Item 3 No Item Exists ......

I'm able to do conditional formatting to change the "No Item Exists...." a different color but I would really like to only display a record where there is no match.

Any help would be greatly appreciated.

share|improve this question

I have not actually tried it but you may be able to this with a custom XSLT template to display when no items are found.

share|improve this answer

Your Answer


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.