SharePoint Search can only Search the Default Zone!

SharePoint Search has some pretty silly limitations, one of them being that it can only search the “Default” zone.  If you’ve already created your site, set it up to be anonymous or forced SSL, SharePoint will be unable to crawl the site. You may see events similar to this in the Application Event Log on the SharePoint server: [text] Log Name: Application Source: Windows SharePoint Services 3 Search Date: 2/11/2009 6:50:06 PM Event ID: 2436
Continue Reading →

SharePoint Integrated Reporting Services “Jump to URL” Does Not Work

If you use the “Jump to URL” feature within a Report, you will note that it works within the Visual Studio designer just fine, but once you deploy your report to a SharePoint Integrated Reporting Services instance, it no longer has a hyperlink associated with that field.  To solve that, use: [text]=”javascript:void(window.open(‘” & “{URL Expression/Value}” & “‘))”[/text]
Continue Reading →

.NET 3.5 SP1 and SharePoint Search Errors

There are a variety of reasons SharePoint Search fails, but this one is particularly exciting.  Here is the error: [text] Log Name: Security Source: Microsoft-Windows-Security-Auditing Date: 1/27/2009 8:30:04 PM Event ID: 4625 Task Category: Logon Level: Information Keywords: Audit Failure User: N/A Computer: SharePointServer Description: An account failed to log on. Subject: Security ID: NULL SID Account Name: – Account Domain: – Log
Continue Reading →

SharePoint 2007 Supported Lookup Column Types

SharePoint only supports a couple Column Types for use with a Lookup: Column Type Supported? Calculated Yes Choice w/ Checkbox No Choice w/ Drop Down List No Choice w/ Radio buttons No Hyperlink No Hyperlink w/ Picture No Multiple Lines of Text No Number No Person or Group No Single Line of Text Yes Yes/No No
Continue Reading →

Formatting SharePoint Data in SQL Reporting Services Report

Depending on the field type, SharePoint may format the data as “#n;Value”.  Not very pretty.  I found this solution somewhere, but don’t remember where.  You can add the below function to your SSRS report by going to Report (when on the Data or Layout tab in Visual Studio/Business Intelligence Development Studio) –> Report Properties –> Code. To use this code in an expression, type: [text]=Code.GetNameFromSP(Fields!MyField.Value)[/text]
Continue Reading →

SQL Reporting Services – Using SharePoint List Data

SQL Reporting Services allows you to leverage SharePoint data via XML query.  The process is fairly simple, although it is hard to find good details on how to do it.  The method below assumes some knowledge with Microsoft Visual Studio 2005 with Business Intelligence (or SQL Server Business Intelligence Development Studio).  You can get this by install the SQL 2005 tools.  The below should also work with the SQL 2008 development tools. To start o
Continue Reading →