The Reporting Services shipped with the Express Edition do not support all features. Unfortunately you can only access a local SQL instance. You can not use XML as Datasource, so no SharePoint Reporting 🙁 A list of supported and unsupported features can be found here.

I updated my tool to set the masterpage Url. Now you can set the masterpage Url for a Web and its subwebs only. Download

Some content types are hidden. This makes it hard to create a new content type, which inherrits from e.g. the “event”. Via the object model it is very easy to create a content type, which uses e.g. “event” as parent. SPSite site = new SPSite( http://serverurl); SPContentType parentContentType = site.RootWeb.ContentTypes[“Event”]; SPContentType newType = new SPContentType(parentContentType, site.RootWeb.ContentTypes, “newName”); site.RootWeb.ContentTypes.Add(newType); Because creating a new content type is just not enough, I wrote a little console application, which lets you create, rename and delete content types for a sitecollection:

Content Types are great to identify your different types of documents and list items. But how can you search for them? In this article I want to show you how to search for your content type via a search scope. First lets create a new content type “contracts”. Go to the rootweb of your sitecollection, and create a new content type: Next, add the new content type to a (new) documentlibrary.

Masterpages are great. You can change the appearance from your website very easy by modifying the default.master masterpage in the root of your sitecollection. But how do you get all pages beneath to use the same masterpage? Some pages use their own masterpage library, and ignore the one from the sitecollection rootsite. With this little tool, you can set the masterpage Url for all subwebs of a sitecollection to the masterpage Url from your rootweb, or some url you specify.

With this Tool you can compare two SharePoint Lists. E.g. if you have a test Server and a live Server, you want to know if you created all your Fields with the correct type. You can download this tool here. **Update: ** Here is an example what you have to write in the fields: http://sourcesite/web/subweb listnumberone http://sourcesite/web/anothersubweb listnumbertwo

SharePoint brings its own controls, which can be used to display list items. In this article I want to show you how to use them in a Webpart. It took me a while to figure this out, because the documentation is kind of incomplete L… OK. Lets start. First lets find out which SharePoint Web Control belongs to which data type in SharePoint. SharePoint Web Control SharePoint data type SharePoint Web Control Single line of text TextField Multiple lines of text PlainText NoteField Rich Text RichTextField Enhanced Rich Text RichTextField Choice Dropdown DropDownChoiceField Radio Button RadioButtonChoiceField Number NumberField Currency CurrencyField Date and Time DateTimeField Lookup Single Item LookupField Multiple Items MultipleLookupField Yes/No BooleanField Person or Group UserField Hyperlink or Picture UrlField Calculated UrlField Business data How do we find which control belongs to the data type?

Mart Muller wrote a great article about the page viewer Webpart. If you put the JavaScript onto the page which is displayed inside the page viewer Webpart, it will auto adjust its height. http://blogs.tamtam.nl/mart/SharePointPageViewerAutomaticallyAdjustIFrameHeight.aspx

If you have a list which contains a SPFieldUser field (with multiple selection), you can add users too it with the following code: using (SPSite site = new SPSite(“http://site”)) { using (SPWeb web = site.AllWebs[“Web”]) <span style="font-family:Consolas;font-size:10pt"> {<br /> </span> <span style="font-family:Consolas;font-size:10pt"> <span style="color:#2b91af">SPList</span> list = web.Lists[<span style="color:#a31515">"List"</span>];<br /> </span> <span style="font-family:Consolas;font-size:10pt"> <span style="color:#2b91af">SPListItem</span> item = list.Items[0];<br /> </span> <span style="font-family:Consolas;font-size:10pt"> <span style="color:#2b91af">SPFieldUserValueCollection</span> values = (<span style="color:#2b91af">SPFieldUserValueCollection</span>)item[<span style="color:#a31515">"Users"</span>];<br /> </span> <span style="font-family:Consolas;font-size:10pt"> <span style="color:#2b91af">SPUserCollection</span> users = web.

In this post I want to show how to create an Ajax Webpart, which receives its data from a Webservice – and until the data arrived – shows a status bar. As base for the Webpart, I took the one from Mark Collins and his great article http://sharethispoint.com/archive/2006/11/15/Build-web-parts-with-ajax.aspx. The approach is to render the Webpart with only a , and let the client – after it finishes querying the Webservice – fill the data into the previously created.

Visual Studio Extensions If you want to write your own Webpart, you can start from scratch with a Class Library, or use the templates from http://www.microsoft.com/downloads/details.aspx?FamilyID=19f21e5e-b715-4f0c-b959-8c6dcbdc1057&DisplayLang=en The downside of this VS templates is, that they can only be used on a computer, which has SharePoint installed, and you cannot open a project created with the VS templates with a VS on which the templates are not installed. Server side controls Ishai Sagi wrote a great article about Webpart development.

Now that we know how to create a simple Webpart, we want to add more functionality to it. Let us start with some Controls. Declare a Control as class variable Create it in CreateChildControls Modify the Control in OnPreRender Render the Control with its content Declare a Control public class simpleWebpart:WebPart { private HtmlGenericControl _MyDiv; CreateChildControls This method creates the control. After the creation, we will be able to access the control from elsewhere, to modify its properties or its content.

To deploy a Webpart to a SharePoint Installation, complete the 3 steps beneath: Copy the dll from your Webpart to the bin folder of a webapplication Register the dll in the web.config as safe Add the Webpart to the Webpartgallery of a sitecollection Debug the Webpart Copy the dll from your Webpart to the bin folder of a webapplication Copy your dll to the bin folder of your IIS virtual server directory.

In this blog post, I want to show you how to create a simple Webpart. All you need is a Visual Studio 2005 (e.g. the express version) and of course SharePoint. Start your VS and create a new “Class Library” Add a reference to the Microsoft.SharePoint.dll. We will create a SharePoint Webpart, to be able to add Properties. To display some text, override the render method. You have to create a reference to the Microsoft.

Instead of posting numerous Blog posts, I created a Wiki-Website on which I will post information about SharePoint programming.