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.