Discover SharePoint Context within an Integrated SSRS report

With SQL Reporting Services integration with SharePoint there may be a need to be contextually aware of the site or list where your report resides.  With the ability to add code or reference custom assemblies in our report we have a starting point to gather this information and leverage information that may be available to…

16

Controlling Page Size in a Reporting Services Report

The default page size in the US is Letter, 8.5in x 11in.  In other parts of the world A4 (8.3in x 11.7in) is the standard.  Reports in Reporting Services are hard coded as part of the design process.  In order to control the page size in the rendering process we need to pass the proper…

3

SharePoint Web Part Embedded Resource Permissions

It is a normal expectation for companies to embed resources like javascript, CSS and other resources in an assembly.  Web Parts are no exceptions.  For those of you that deploy everything to the GAC, you can disregard the remainder of this post.  The rest of you, bear with me.  If we are not deploying to…

3

Reporting Services: What Happens When I Upgrade

Recently we were involved in a conversation around upgrading from SSRS 2005 to SSRS 2008.  The credit for this post goes to Robert Bruckner who guided us during the internal discussion.  When you move from SSRS 2005 to SSRS 2008 there are things that happen internally that may be unknown to you.   If you upload…

2

Finding a SharePoint List Template Id

There are several ways to find out the ID for a List.  A typical scenario where a list template id is required is querying a list or set of lists using SPSiteDataQuery.  You can find the list template id by looking at the 12\TEMPLATE\FEATURES directory and finding the list in question.  Opening the element manifest…

6

Unravel the SharePoint Threaded Discussion

The SharePoint Threaded Discussion is a forum type of post.  Underneath, like all things SharePoint, it is a list.  By default that list is made up of two content types, Discussion and Message.  The content types have IDs of 0x012002 and 0x0107 respectively.  Following the content type inheritance chain this means that the Discussion content…

13

SQL Server 2008 RC0 canonical errors during setup

I was installing the RC0 version of SQL Server 2008 this weekend and kept running into the following error: This access control list is not in canonical form and therefore cannot be modified. There were a lot of these errors in the Feb CTP related to the registry which seemed to have been resolved.  The…

12

Creating a ‘Link to a Document’ Item in a SharePoint Document Library programmatically

One of the new features available in SharePoint 2007 are content types.  Content types allow you to classify content to be a particular type.  By marking content as a particular content type the metadata, workflow and policies associated with that content type are leveraged instead of default policies that may apply to a standard document. …

45

SharePoint Webs web service CreateContentType and UpdateContentType

I was experimenting with the SharePoint Webs web service CreateContentType and UpdateContentType methods recently.  The goal was to create a base content type and update it by adding an additional column with a separate web service call.  According to the documentation you are suppose to use the <FieldRefs><FieldRef /></FieldRef> Xml structure to create an XmlNode…

3

Adding Web Parts to the Web Part Gallery Using the SharePoint Object Model

Since my first post was based on removing web parts from the web part gallery of a ‘My Site’ there have been questions about how to add the web parts back should circumstances require it.  This is pretty straight-forward, but can get more interesting depending on how robust you want to make the end solution. …

2