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 :
Microsoft Dynamics CRM (Archived)

FetchXML Reporting Question

(0) ShareShare
ReportReport
Posted on by

I have created a report in VS using FetchXML. I have it running off of Contacts and then I have other data sets of related records that i have linked to the contact through the contactid. For whatever reason I am getting an error when I load it into the CRM environment even though when I click on "Edit Filter" the contact's name is correct. Can anyone help me with this?

The initial Contact data set has the enableprefiltering = "1" and the other data sets are currently linked using <condition attribute="record1id" operator="eq" value="@CRM_contact" />

Any advice would be greatly appreciated

Thank you

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    21 on at
    RE: FetchXML Reporting Question

    If you are using on prem you can check the ssis logs in the sqlsever program directory - Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    - but if you are online then the only option is to create a report using the report wizard and download - you can then compare with your report, or remove components from your report until it works.

    See community.dynamics.com/.../solutions-to-issues-with-reports-in-dynamics-crm-2011.aspx

    Hope this helps,

    Scott

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…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans