CRM 2011: Custom Reports & the rsProcessingAborted Error

I created a custom report for CRM 2011 in BIDS , but it is throwing an error “The report cannot be displayed. (rsProcessingAborted)” message . Out-of-the-box reports would display fine.

Reporting Error:

The report cannot be displayed. (rsProcessingAborted)

Resolution: It was not having the permission to connect to the CRM Database.

1> I then opened my SQL.

2> Went to Security -> Logins

3> Right Click NT Authority\SYSTEM (in my case)

4> Selected user Mapping

5> Checked the MSSCRM_CONFIG and Org_MSCRM with roles of :

·         CRMReaderRole

·         public

·         db_ownwer

After this refresh the database to resolve this.