web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Error: Blank Report us...
Microsoft Dynamics CRM (Archived)

Error: Blank Report using FetchXML CRM 2011

(0) ShareShare
ReportReport
Posted on by yahikochan1 75

Hi everyone,

Recently i had to create some reports for a client. I made the reports using the embedded report wizard creator. Now when I go to the report a press the run button the report display a blank page.

If I download the .rdl file and open it in VS2008 BIDS in the preview tab I can see all the data but when I try to run it I get the following Error:

An error occurred during local report processing.

An error has occurred during report processing.

An attempt has been made to use a data extension 'MSCRMFETCH' that is either not registered for this report server or is not supported in this edition of Reporting Services.

My setup is the following:

1 CRM Server with Rollup 11 installed.

1 SQL 2008 R2 Developer with SSRS with Microsoft Dynamics Reporting Extension and Microsoft Dynamics Authoring Reporting Extension installed.

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mohammad Atif Profile Picture
    Mohammad Atif on at
    Re: Error: Blank Report using FetchXML CRM 2011

    Do you have multiple orgs and user user account is part of those Orgs, and one of the org is in desabled state. this is one of the possiblity that you can see this behvaior

    other, please make sure you have SPn set for the Service account in with the CRM App Pool is running under and the account for the SRS Services.

    Thanks,

  • Suggested answer
    yahikochan1 Profile Picture
    yahikochan1 75 on at
    Re: Error: Blank Report using FetchXML CRM 2011

    thx Mohammad.

    I run the setspn command to register the services accounts that are used for the CRMAppPool and CrmDeploymentServiceAppPool in IIS 7

    the command i run was:

    setspn -a http/[CRMSERVERNAME] [ACCOUNT]

    setspn -a http/[CRMSERVER.FQDN] [ACCOUNT]

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
UllrSki Profile Picture

UllrSki 2

#3
SC-08081331-0 Profile Picture

SC-08081331-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans