SSRS – Report Server has encountered a SharePoint error – User cannot be found

Executing a SSRS report in the VS works fine, but when deployed in SP environment throws error "User cannot be found". Below is the detailed error. System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Report Server has encountered a SharePoint error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: User cannot be found.    --- End of inner exception... Continue Reading →


Suggestions for creating SSRS reports using data from SharePoint list

When your business user wants a report based on the data stored in your list, you may want to leverage SQL Server Reporting Services for this. In this case to to retrieve the data in your reports, the available options are: Query the SharePoint database. Although it’s an option, this is NOT AT ALL recommended.... Continue Reading →

SharePoint Workflow status codes

Here are the workflow status codes which are required, for example, you want to filter a view on the workflow status. The status enumeration is defined by the SPWorkFlowStatus enum, within the Microsoft.SharePoint.Workflow namespace in the Microsoft.SharePoint assembly. In case if you are retrieving the list values in a SQL Reports using the SharePoint provided web... Continue Reading →

Create a website or blog at

Up ↑

%d bloggers like this: