Reporting error. Report cannot be displayed. (rsProcessingAborted)

I was getting the above error while running one of the custom SSRS report inside CRM 2011.

To resolve this issue I had to follow these steps

1. Start SQL Server Management Studio
   
2. Expand Security, then expand Logins
   
3. Select and right click the account under which the SQL Server Reporting Services is running.
   
4. Select User Mapping and select YouOrg_MSCRM database and specify following role membership
   

• CRMReaderRole,
  
• db_owner
  
• public.
  

Hope it helps.

Filed under: CRM, CRM 2011, Microsoft Dynamics CRM, SqlServer Reporting Services Tagged: CRM, CRM 2011, CRM 4.0, CRM SQL Reporting Services, Microsoft Dynamics CRM