Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

The report cannot be displayed. (rsProcessingAborted)

Posted on by

Hello All Experts,

I am facing the challenge while trying to open the (The report cannot be displayed. (rsProcessingAborted) )

By following one of the thread am trying to see the log but the directory is not available where the logs gets generated.

<SQL INSTALLDIR>\MSRS11.MSSQLSERVER\Reporting Services\LogFiles.

from the above path the highlighted folder is misssing .

Any help will be appreciable.

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: The report cannot be displayed. (rsProcessingAborted)

    Hi Guys,

    I followed below link

    www.inogic.com/.../

    and as per the link there is one spn command which i have run on the Active directory server and report is working fine now.

    May be this would be helpful for others as well.

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: The report cannot be displayed. (rsProcessingAborted)

    Hi Wahaj Rashid,

    Yes you are correct , this is our on premise version.

    I am using fetch based reports and not sql query.

    in visual studio report is working fine, even deployed on dev environment from bin->release folder it's working fine.

    From DEV environment to Test it is moved in managed solution and there it is giving an issue.

    When connecting the Test crm environment through visual studio report is working fine, but from within crm it's not working.

  • Suggested answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: The report cannot be displayed. (rsProcessingAborted)

    Hi,

    I assume you have an on-premise environment and your reports works in the Visual Studio.

    You can check the Error on the Event Viewer (Application) log as well (on your reporting/DB server).

    Furthermore, please verify:

    • You have used the Filtered Views (if it is a sql query).
    • Depending on your CRM version, your report project TargetServerVersion should be changed, for example:

    pastedimage1622544785052v1.png

    • Once you build the report, copy it from the Bin/Debug or Bin/Release folder (this will have the correct Target Version).
  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: The report cannot be displayed. (rsProcessingAborted)

    After digging little more i am getting below error.

    The EXECUTE permission was denied on the object 'p_GetCrmUserId', database 'MSCRM_CONFIG', schema 'dbo'.

    How to resolve this issue now.

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: The report cannot be displayed. (rsProcessingAborted)

    After running the report using report server url i am getting the below error.

    An error has occurred during report processing. (rsProcessingAborted)

    Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)

    Microsoft.Crm.CrmException: An unexpected error occurred. System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

    An unexpected error occurred.

    Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans