Mapping with Virtual Earth in SQL Server Reporting Services After seeing an excellent article by Wayne Berry about Mapping in SQL Server Reporting Services using the Google Maps API, I was inspired to see what I could do with Virtual Earth. The answer: not much. Virtual Earth does has a stellar SDK. The SDK is all JavaScript based, so it may not be used by SQL Server...

Easy multi-value parameters in SQL Server Reporting Services I recently came across an application where I needed to use a multi-value parameter in SQL Server Reporting Services (SSRS).  I always seemed to have trouble with these in the past.  This time I found them very easy to use because I found (re-discovered?) a simple way. The basic idea is to set up a...

CAML queries, SSRS, and datetime fields I’ve been using Enesys Software’s product RS Data Extension to query data out of SharePoint 2007 lists in SQL Server (2005) Reporting Services.  One quirk with the queries is that they use CAML and the dates must be in a particular format, ISO8601. I wanted users to use the standard date-picker,...

SharePoint “User not found” error with Reporting Services in integrated mode I encountered an error the other day while trying to get a SharePoint 2007 (WSS 3.0) site running with SQL Server Reporting Services 2005 in integrated mode.  While trying to access any report .RDL files inside a document library, I got the “User not found” error from SharePoint.  After looking...