CAML queries, SSRS, and datetime fields
Posted by Aaron in SQL Server Reporting Services, WSS 3.0 on 09 24th, 2008 | 1 Comment
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,...
Read More
SharePoint “User not found” error with Reporting Services in integrated mode
Posted by Aaron in SQL Server Reporting Services, WSS 3.0 on 08 6th, 2008 | No Comments
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...
Read More
Page 2 of 212