web
You’re offline. This is a read only version of the page.
close
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) / User having issues wit...
Microsoft Dynamics CRM (Archived)

User having issues with reports in CRM

(0) ShareShare
ReportReport
Posted on by Drew Inc. 1,680

Hello,

One of my client user is having issue running the report. Same security role is assigned to all the client users all are able to records except one. He is running the report, but not able to see any records in the report. Can any one provide inputs for this? Thank you!

Drew

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at

    Check event log on server and see any error related to report there when this particular user is running report.

    Event log will help you find exact problem.

  • Drew Inc. Profile Picture
    Drew Inc. 1,680 on at

    Well there is no error, it is not giving me any records. Just returns the blank report. I will check again and let you know if the logs contain any information

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Please check in sql with the query for this particular user.

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Drew,

    Your report is using SQL FilteredView?

    Thanks,.

  • Drew Inc. Profile Picture
    Drew Inc. 1,680 on at

    Alright seems like the user is not able to access reports hosted in the related reporting server across different organisations. I tried to make use of reporting server URL directly, it didn't work either. He is just seeing blank reports.

    Aileen, no it is just one fetch xml which we are using for the reports.

    Mahadeo Matre, No error in logs too. Now I don't have any idea where to look for this.

  • Drew Inc. Profile Picture
    Drew Inc. 1,680 on at

    Finally we got that resolved.

    Problem is User is added to different organisation in the same server at first.

    We disabled the default organisation since we no longer use this. The default org for that particular is still pointing to disabled organisation.

    CRM for some reason using this and failing to render the reports, so we changed the default org for that particular user. Everything seems to be working fine now.

    Relevant help in the url - > blogs.msdn.com/.../microsoft-dynamics-crm-2011-unable-to-run-any-reports-due-to-missing-security-role-in-default-organization.aspx

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans