The first post in this series focused on creating some core validation logic to validate a user request.  With the core validation completed the next step is to wire up all the pieces required by SQL Reporting Services.  This includes implementation...

This will be the first in a series of posts related to setting up single sign on for SQL Reporting Services.  As you may know SQL Reporting Services supports forms authentication and there is a forms authentication sample that can be found here ...

Using Dashboard Designer in SharePoint 2010 allows one to build powerful visualizations for end users.  Unfortunately the ability to style the output is limited in the designer.  With a little CSS it is possible to take the generated dashboard...

This is one of those posts you hope will save a lot of people some time, but also a place to store my notes related to installing a complete developer machine on Windows Server 2008 R2 with local accounts, PowerPivot, and a full installation of SQL Server...

I was recently working with a customer with some localization behavior in SharePoint.  What I didn’t realize at the time was the way that GetLocalizedString() works.  The fallback behavior of .NET looks first for the specific language-locale...

In the last post we addressed the basics of implementing the SharePoint thesaurus file using a SharePoint list.  This included creating the content type, fields and list schema we would use to make this a reality.  As part of that exercise we...

I have seen a few implementations of SharePoint Thesaurus generators that use various means to manage the data in a thesaurus file and then generate the file.  Why not use a SharePoint list to do the same thing.  If you are using Excel, as most...

SharePoint 2010 changed the way team sites worked. Now the home page is more of a WIKI implementation that allows you to intermingle content and web parts together in a rich text area. In my opinion this is a good thing. You will notice that the home...

There have been a few comments lately on this post I made a while back on how the threaded discussion works. Their question revolves around working with the SharePoint threaded discussion via web services, and more specifically how to post a response...

This post comes form another question generated from a customer. I have encrypted my web.config section and I want to be able to pull that information out of the configuration file. That’s easy right, .NET takes care of that? Typically it does, given...

For those of you exploring the beta of SharePoint 2010 you may be aware of a new feature called the developer dashboard. The developer dashboard is similar to the trace capabilities you have in ASP.NET where you can display execution variables and other...

I was recently challenged with trying to come up with a least privilege scenario for running a console application or windows service against a SharePoint Farm to perform read-only type operations. Without the correct permissions there are several exceptions...

I have seen a few reports recently that have been upgraded from SSRS 2005 to SSRS 2008 where a ‘Value either too Large or too small for a decimal’ appears in the chart under certain circumstances. This typically manifest itself when an expression in the...

I can’t take credit or this one, but a colleague I have been working with was able to figure this out. He doesn’t blog, so I am sharing it with the greater community. Our quest was to upload a document into a document library using the Copy.asmx web service...

In working with a customer doing a migration from Reporting Services 2005 to 2008 an error appeared when in preview mode that didn’t appear in the previous version. The error was simply #Error in the report and the Error pane in Visual Studio showed The...

I work in the ISV Practice here at Microsoft. There are two tools recently released to the SharePoint community that should have ISVs and Enterprise customers excited. SPDisposeCheck provides a static source code analysis tool to check for leaks that...

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...

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...

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...

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...

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...

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...

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...

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...

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...