web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / issue with report and ...
Microsoft Dynamics CRM (Archived)

issue with report and missing field values

(0) ShareShare
ReportReport
Posted on by Megan V. Walker 1,856 Most Valuable Professional

I have fairly simple FetchXML query for a report: 

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="opportunityproduct">
<attribute name="productid" />
<attribute name="productdescription" />
<attribute name="priceperunit" />
<attribute name="quantity" />
<attribute name="extendedamount" />
<attribute name="opportunityproductid" />
<attribute name="opportunityid" />
<order attribute="opportunityid" descending="false" />
<link-entity name="opportunity" from="opportunityid" to="opportunityid" visible="false" link-type="outer" alias="opp">
<attribute name="statecode" />
<attribute name="ownerid" />
<attribute name="actualclosedate" />
</link-entity>
</entity>
</fetch>

All of the records I expect are being returned below. However, I don’t want the second column in the report (OpportunityidValue). 

first-image.jpg

When I remove it from the table, some of the opportunity names disappear, along with the column header. I have no groups, and no sorting or filtering on the details row (which is where the table is). Does anything jump out in the query that could cause this? 

0312.image-2.jpg

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Megan, 

    You can try to use some fetch xml query, but from the table remove manually second column or set for second column visibility property to false. 

    Hope this helps

    Vlad
    http://dynamicalabs.com/

  • ashlega Profile Picture
    ashlega 34,477 on at

    Hi Meagan,

    try adding "name" to the link-entity attributes, and use that field for the first column(it'll probably look like opp.name in the dataset):

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

    <entity name="opportunityproduct">

    <attribute name="productid" />

    <attribute name="productdescription" />

    <attribute name="priceperunit" />

    <attribute name="quantity" />

    <attribute name="extendedamount" />

    <attribute name="opportunityproductid" />

    <attribute name="opportunityid" />

    <order attribute="opportunityid" descending="false" />

    <link-entity name="opportunity" from="opportunityid" to="opportunityid" visible="false" link-type="outer" alias="opp">

    <attribute name="statecode" />

    <attribute name="ownerid" />

    <attribute name="actualclosedate" />

    <attribute name="name" />

    </link-entity>

    </entity>

    </fetch>

  • Megan V. Walker Profile Picture
    Megan V. Walker 1,856 Most Valuable Professional on at

    Hi Vladimir, even if I change the second column visibility and hide it, the same issue occurs. Thanks for your suggestion!

  • Verified answer
    Megan V. Walker Profile Picture
    Megan V. Walker 1,856 Most Valuable Professional on at

    Hi Alex,

    I added the name attribute as suggested. Still the same missing field issue occurred.

    However, I published to CRM just to see how it looked, and all of the field values on all rows populated. In conferring with a work colleague, he shared the following:

    SSRS uses different rendering engines, for different environments.  So if you write a report in BIDS it will not use the exact same background process to generate the output as it does in the browser.

    Then, to add more joy…. There are different rendering engines for all the different formats too.

    Let’s say you write a report, with a specific format that you have to adhere to, The output (and even the result built in logic)  can be different when the report is generated via…

    • Design time (BIDS)

    • Viewed in Browser

    • Exported to PDF

    • Exported to Excel

    So one report can have many different end results depending on the method of generating it. I think I have learned to review in CRM if I see funky things like this happening again!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans