The report cannot be displayed. (rsprocessingaborted) in CRM 2011(Part-1)

To find out the actual error, go to the SQL Reporting Services Server, and look at the log file in

C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles.

To resolve this issue I had to follow these steps

Start SQL Server Management Studio
Expand Security, then expand Logins or select the CRM database and click securitiy and click logins/users
Double click PrivReporting Group,
Check db_owner and CRMReaderRole




or
May be this issue because of SPN

SPN:
Put simply, an SPN (Service Principal Name) mapping allows a service on a particular server to be associated with an account responsible for the management of the service, thereby permitting mutualKerberos Authentication. To use mutual Kerberos authentication, the Windows security layer must be able to determine the account that a service is using.

Simple explanation:

CRM can have a database server separate to the Application Server (where IIS is hosted). For security purposes, it is advisable to run CRM as a service account which is also existed on Domain.

Similarly, it is advisable to run SQL server on the Database server in a separate service account on domain.

So, when SPN is not configured Application server is not able to authenticate SQL server as both are running under different accounts.

SPN creates a mapping so that Authentication can happen and thus reports start working most times after this is configured correctly.

This is one of the best documented ones: http://blog.simpletrees.com/2013/04/mscrm-and-dreaded-rsprocessingaborted.html

Thanks to Deepesh Somani for sharing good explanation of SPN.