SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

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 know it's a common SharePoint problem. I want to accumulate two SharePoint lists on MOSS 2007. One is a calendar list and the second a custom list with a date column. I want both in another list. The only function the target list must have is to show the items of both lists. There mustn't be a function for creating new items on this list. The view should be near realtime.

What should I use?

share|improve this question
up vote 6 down vote accepted

If you have access to Sharepoint Designer then a Dataview Webpart will do this nicely. You can convert it to xsl and ensure there are no options to edit the items. There are plenty of examples of creating these on the net. I recommend looking for examples from Laura Rogers.

share|improve this answer
This would definately be the easiest option.… – Nick Hadlee Mar 10 '10 at 8:13
Agreed - A merged data source with a DVWP is the solution here. – Charles Lee Mar 10 '10 at 9:42

If you customize anything in SharePoint Designer, remember, that it will break the attachments toolbar.

share|improve this answer
Certainly this is true if this was a custom form. In this case it is just a view and should not be affected. – spevilgenius Mar 10 '10 at 22:04

Your Answer


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