web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) FetchXML Report showin...

Microsoft Dynamics CRM (Archived)

FetchXML Report showing odd field names in SSRS

(0) Share

Report

Report

Posted on by Frosty8467

50

I ma trying to create a FetchXML report using Visual Studio 2015 using the fetch below

<fetch>
<entity name="msdyn_timeentry" >
    <attribute name="msdyn_date" alias="Date" />
    <attribute name="msdyn_duration" />
    <attribute name="msdyn_project" />
    <link-entity name="systemuser" from="systemuserid" to="ownerid" link-type="inner" visible="true" >
      <attribute name="fullname" alias="Employee" />
      <link-entity name="new_clockworxpricing" from="new_clockworxpricingid" to="new_employeetype" >
        <attribute name="new_chargeoutrate" alias="ChargeOut" />
        <attribute name="new_chargeoutrate_base" alias="ChargeOutBase" />
      </link-entity>
    </link-entity>
    <link-entity name="msdyn_project" from="msdyn_projectid" to="msdyn_project" >
      <attribute name="msdyn_customer" />
    </link-entity>
</entity>
</fetch>

All the fields show correctly except msdyn_customer which appears with a 7 char hex number in the middle as below

[msdyn_projectb82a0515_msdyn_customer] and doesn't show on the report when I run it.

Have I missed something in the link or is it something in the CRM that needs to change?

Thanks in advance for your help

Frosty

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Suggested answer

Thomas David Dayman 11,323 on at

Like (0)

Report

You should replicate this fetch using the FetchXMLBuilder. Then you will know if you fetch is correctly formatted or not.

Was this reply helpful? Yes No
Frosty8467 50 on at

Like (0)

Report

I used FetchXMLBuilder to create the query in the first place and it returns the data I want. It's when I get it in to SSRS I get these weird attributes that don't show anything.

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report

Please try to add alias name -

<attribute name="msdyn_project" alias='msdyn_project'/>

Was this reply helpful? Yes No
Frosty8467 50 on at

Like (0)

Report

Goutam,

Legend worked perfectly. Thank you so much.

Seasons Greetings to you and yours.

Thanks

Frosty

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans