June 18, 2012

Error when using SharePoint list as SSRS DataSource

I'm using a SharePoint 2010 list as a DataSource in SQL Reporting Services 2008 R2 (see msdn.microsoft.com for more info on how to set that up).  When I use the query designer to get the acutal data I was getting the error message below.  I could see the columns in the chooser, so I knew I had permissions to at least see the list.

Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.  List does not exist.  The page you selected contains a list that does not exist.  It may have been deleted by another user.  0x82000006

Switching over the the "Edit as Text" I noticed the "Command type" didn't have anything selected.  I selected "Text", clicked the execute query button again and now I have data.

By the way, removing everything between and including the <ViewFields> tags will return all columns in the list... which may or may not be desirable.  I have them removed in the image above, but by default they're there.