Development

Even if the Reporting Services are very powerfull, you might get to the point where you have to extend the building functionality. So why not write your own custom assembly with some additional code? Create your assembly like this: 1: using System; 2: using System.Security.Permissions; 3: using Microsoft.SharePoint; 4: 5: public class MyNamespace 6: { 7: public class ReportingExtension 8: { 9: public ReportingExtension() 10: { 11: } 12: 13: public static string HelloWorld() 14: { 15: return "Hello World.

Please use my custom field type. It is more flexible –> http://www.hezser.de I updated my Wiki Webpart. For all of you who don’t know what it does: The normal Wiki Edit Form misses the ability to upload pictures. My Webpart, which has to be included to the EditForm.aspx, allows you to upload a picture. It also creates a link in your Wiki post, which displays the uploaded image. This release of the Webpart is multi lingual.

The updated SDKs are now available for downloading. SharePoint Server 2007 SDK: Software Development Kit and Enterprise Content Management Starter Kit Windows SharePoint Services 3.0: Software Development Kit (SDK)

Whenever you have an ID from a list item, you might want to create a link to its DispForm or EditForm. But how do you get the Url to the forms? 1: SPList list = something; 2: list.Forms[PAGETYPE.PAGE_DISPLAYFORM].Url;

For exception handling it is good practice to write errors to the eventlog.EventLog.WriteEntry(“SharePoint.Error”, errorText, EventLogEntryType.Error); Since SP1 for Windows Server 2003 “the normal user” is not allowed to write to the eventlog. James Kovacs wrote a great article about the problem. (Remember to create your eventlog source, if you have your own!) 1: if(!EventLog.SourceExists(“SharePoint.Error”, ".")) { 2: EventLog.CreateEventSource("SharePoint.Error", "Application", "."); 3: }

If you want the ID or the value form a LookupField, you can get it easily with this code snippet:SPListItem item = getitsomewhare… SPFieldLookupValue lf = (SPFieldLookupValue) item.ParentList.Fields.GetField(_FieldName).GetFieldValue( item.GetFormattedValue(_FieldName)); if you got the field, fetch its properties viaif (lf == null) { int itemID = lf.LookupId; string itemValue = lf.LookupValue; } Have fun ;-)

I started to write a Webpart, which shows the content of a remote website. You can specify logon information, as well as proxy information. **It is not ready yet! But I was asked for it. So I will publish it unfinished! ** Download

Fetching a listitem by ID will generate an error, if the a listitem with the ID does not exist. To avoid this exception, you can get a listitem by id by searching for it:private SPListItem GetListItem(SPList List, int ListItemID) { try { string defaultView = List.DefaultView.Title; SPQuery query = new SPQuery(List.Views[defaultView]); string caml = String.Format("{0}", ListItemID); query.Query = caml; SPListItemCollection results = List.GetItems(query); if (results.Count == 1) { return results[0]; } } catch (Exception ex) { _ErrorMessage +=

You can display multiple list items with SharePoint and SharePoint Designer quite easy. But how do you display a single listitem? I worte a Webpart, which does this. If there are more than one listitem, you can page through them. And if you like, you can pass an itemid via a Webpart connection. In the Webpart properties you can select the list/library. If you like, you can specify a view other than the default view.

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:

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?

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”]) { SPList list = web.Lists["List"]; SPListItem item = list.Items[0]; SPFieldUserValueCollection values = (SPFieldUserValueCollection)item["Users"]; SPUserCollection users = web.

Development

Custom assemblies for the Reporting Services 2005

Updated Wiki Webpart

updated SDKs

Get form Url from a list

Create an eventlog entry

How to get LookupField Information from a listItem

Display a website, which requires authentification

Get a listitem by ID

Display a single listitem

Setting the masterpage Url (Update)

Create/Rename/Modify content types

Setting the masterpage Url

Compare SharePoint Lists

How to use the SharePoint Web Controls

Write a SPFieldUser