Report cannot be displayed (.Rs processing aborted)

(0) Share

Report

Posted on by Krishna potdar

317

Dear All,

I have created the SSRS report using SQL Query and deployed the same in reporting service configuration manager it is working fine ,but when i click on Run report in MS CRM instance it was throwing this error

1385.Error.PNG

I have gone through these points but still it didn't worked.

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

CRMReaderRole,

db_owner

public.

Please can anyone suggest me for the same.

Regards,

Krishna.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Iswarya 1,347 on at

Like (0)

Report

RE: Report cannot be displayed (.Rs processing aborted)

Hi,

try this

stackoverflow.com/.../the-report-cannot-be-displayed-rsprocessingaborted

Was this reply helpful? Yes No
Ganesh Chowhan 160 on at

Like (0)

Report

RE: Report cannot be displayed (.Rs processing aborted)

Hi,

There could be many reasons for this.

Please check report server error log for exact issue/ exception.

Possible reasons for this:

1. Authentication failure/ Database login failed/ permission issue to DB/ Table.

2. Error in query.

3. verify registered SPNs.

4. Also you may check which user is getting passed to SQL from SSRS report; used UserId parameter from Built-in fields to display user id or trace in SQL query.

Thanks

Ganesh

Was this reply helpful? Yes No
jdalske 545 on at

Like (0)

Report

RE: Report cannot be displayed (.Rs processing aborted)

I am having the same issue but when I select our report user everything looks correct. This just started happening and oddly enough we pushed out updates last week.

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

RE: Report cannot be displayed (.Rs processing aborted)

The Reporting Services log files should give more information on the error

Was this reply helpful? Yes No
jdalske 545 on at

Like (0)

Report

RE: Report cannot be displayed (.Rs processing aborted)

I figured out what was happening on my end. I had to open IE as a different user and sign in as our admin account. From there I navigated to org and changed the view from tiled to detail and saw a hidden folder. The report was being published in there. I could then configure my schedule.

Was this reply helpful? Yes No
Suggested answer

ajyendra 1,738 on at

Like (0)

Report

RE: Report cannot be displayed (.Rs processing aborted)

Hi,

Refer this they have a solution

https://nishantrana.me/2011/05/26/reporting-error-report-cannot-be-displayed-rsprocessingaborted/

also for debug

https://community.dynamics.com/crm/b/crminogic/posts/how-to-debug-rsprocessingaborted-report-error

Hope it Help

Was this reply helpful? Yes No
Amirhosein 2 on at

Like (0)

Report

Report cannot be displayed (.Rs processing aborted)

hi,
there could be many reason for this but in my case I tried this steps and worked

1.check data source of every report that is published in report server, make sure test connection is successful
2.check connection string of report server to db server on regedit
hkey_local_machine..>software..>microsoft..>mscrm..>configdb

Was this reply helpful? Yes No