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) / CRM Report Fails
Microsoft Dynamics CRM (Archived)

CRM Report Fails

(0) ShareShare
ReportReport
Posted on by SamCRM1 247

I am trying to create a simple report using CRM Report Wizard. But when I try to run it, its giving the error "".

8372.ReportError.jpg

I looked in the database log and it says: "Query execution failed for dataset 'DSMain'."

Can somebody please tell me how can I fix this issue. 

Thank you,

Sam

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    Check if it is your case - support.microsoft.com/.../error-message-when-you-try-to-create-a-report-by-using-the-report-wiza

  • SamCRM1 Profile Picture
    SamCRM1 247 on at

    Hello Andrew, Thanks for your reply. I too found this post yesterday but I don't think thats what is happening in my case. I am trying to run the report on a custom entity I created.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    In this case check Reporting Services Logs for detailed error - mscrmuk.blogspot.co.uk/.../reporting-services-log-files.html

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