Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Issue with FetchXML Reporting - Missing [logicalname]Value fields in data sets

Posted on by Microsoft Employee

Hello.

When trying to design a custom fetchxml report, I'm running into an interesting problem that I'm wondering if somebody can assist with.

Suppose I have a simple Fetchxml query

<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0" >
<entity name="incident" >
<attribute name="title" />
<attribute name="ownerid" />
<attribute name="statuscode" />
</entity>
</fetch>

The dataset should be returning:

  • title
  • ownerid
  • owneridValue
  • owneridEntityName
  • statuscode
  • statuscodeValue

But all I'm getting is:

  • title
  • ownerid
  • statuscode

Anyone know what might be causing this?

FYI:

  • I've tried against SSDT 2012, 2013
  • I have Report Authoring Extensions installed (it's up to date from what I know)
  • This query/report works fine on another machine with a seperate SSDT 2012 installed!!
    • The .rdl xml is identical, except for the [logicalname]value code missing
    • If I try to manually add these fields into the broken environment, and then add the fields to a table in the report, the report just lists the fields as blank.

Any thoughts would be greatly appreciated!

Steve

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Issue with FetchXML Reporting - Missing [logicalname]Value fields in data sets

    Hello. The answer came back luck. Turns out the client was on version 8.0, which doesn't work with 9.0 Report Authoring Extensions... Next time I should probably check the CRM version.

  • Suggested answer
    Arun Vinoth Profile Picture
    Arun Vinoth 11,613 on at
    RE: Issue with FetchXML Reporting - Missing [logicalname]Value fields in data sets

    Should work. community.dynamics.com/.../254433

    Probably SSDT installation or project corrupted. Can you repair/restart VS & machine for pending updates.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans