Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Report cannot be displ...
Microsoft Dynamics CRM (Archived)

Report cannot be displayed (.Rs processing aborted)

(0) ShareShare
ReportReport
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.

  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.

Please can anyone suggest me for the same.

Regards,

Krishna.

*This post is locked for comments

  • Amirhosein Profile Picture
    Amirhosein 2 on at
    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
  • Suggested answer
    ajyendra Profile Picture
    ajyendra 1,732 on at
    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

  • jdalske Profile Picture
    jdalske 536 on at
    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.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: Report cannot be displayed (.Rs processing aborted)

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

  • jdalske Profile Picture
    jdalske 536 on at
    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.

  • Ganesh Chowhan Profile Picture
    Ganesh Chowhan 160 on at
    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

  • Suggested answer
    Iswarya Profile Picture
    Iswarya 1,345 on at
    RE: Report cannot be displayed (.Rs processing aborted)

    Hi,

    try this

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans