Andy Lewis over at the Microsoft SharePoint Designer Team Blog has a nice post about how to do Filtering and Formatting with Date Values. The best part of the post (it is FULL of useful information) is a set of utility templates that do some useful calculations on dates: getDateFromDays Outputs the date that is…
I posted back in February about using the Data View Web Part to do cross list rollups (See Rolling Up Content in SharePoint Using the Data View Web Part (DVWP)). Since then, I’ve done quite a few of these, and I’ve been meaning for some time to post this update. Not everything that I believed…
I recently updated my Windows XP SP3 machine with some recommended updates from Windows Update. After I did so, I received the following error every time I tried to open a Datasheet view in SharePoint: The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible…
Here’s an easy one — except that most of your users won’t know about it. I was just asked how someone can know about how much disk space they are using with their SharePoint sites. Well, lo and behold, if you are a Site Collection Administrator, you can (at the root of the Site Collection),…
One of the big "gotchas" in coding against the SharePoint Object Model is not disposing of resources properly. In relatively little time, you can find that your server is cycling itself to free up resources, with no apparent reason. The first thing you should check is your own code. Roger Lamb has written an excellent,…
My client was seeing an odd error in one of their environments, bot not any of the others. When you would go to configure an out-of-the-box workflow on a site, you’d see the "The form cannot be displayed because session state is not available." error after clicking Next on the first configuration screen (/_layouts/AddWrkfl.aspx). Some…
Oftentimes you’d like to mimic the out of the box display capabilities of SharePoint when you create a view using a DVWP (Data View Web Part or Data Form Web Part). One of the things you might like to do is to show the document type icon for the documents in your view. These are…
This seems to be a fairly widespread issue with no clear solution. It occurs when the user chooses the ‘Export to Spreadsheet’ Action and the SharePoint list view has a Date/Time column displayed. With Excel 2007, the data is exported to Excel just fine, but with Excel 2003, the above error is shown in a…
I ran into an instance today where a column’s data contained the ampersand (&) character when I hadn’t expected it to. Since the ampersand is used to separate Query String name/value pairs in the URL, that ampersand was causing me problems. In general, you should always encode Query String values just in case they might…
Over the last week or so, I’ve had the opportunity to work with the reports available in Quest’s Site Administrator for SharePoint toolset. The out of the box reports that it provides can help you greatly in administering your farm. See this PDF document for a list of all of the out of the box…