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

Custom Report Current Record Sub-Report not showing data

(0) ShareShare
ReportReport
Posted on by

I have created 2 reports.

1) Report 1 will display quote values which works fine and display on the current record.

2) I have created report 2 and reference this report in Report 1 sub report. Added parameter and it display the data when I preview the records.

I build and upload the Report 1 and sub report values are not displayed. Only parent report values displayed.

Report 1 Fetch XML

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="quote" enableprefiltering="1">
    <attribute name="name" />
    <attribute name="customerid" />
    <attribute name="totalamount" />
    <attribute name="quoteid" />
    <attribute name="createdon" />
    <attribute name="totaltax_base" />
    <attribute name="totaltax" />    
    <attribute name="new_quotetype" />
    <attribute name="quotenumber" />   
    <attribute name="discountamount" />
    <attribute name="discountpercentage" />   
    <attribute name="opportunityid" />    
    <attribute name="modifiedby" />   
    <attribute name="effectiveto" />
    <attribute name="effectivefrom" />    
    <attribute name="description" />   
    <attribute name="createdby" />   
    <order attribute="name" descending="false" />  	
  </entity>
</fetch>

Report 2

<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="quotedetail">
<attribute name="productid"/>
<attribute name="productdescription"/>
<attribute name="priceperunit"/>
<attribute name="quantity"/>
<attribute name="extendedamount"/>
<attribute name="quotedetailid"/>
<order descending="false" attribute="productid"/>
<link-entity name="quote" alias="aa" to="quoteid" from="quoteid">
<filter type="and">
<condition attribute="quoteid" value="@QID" operator="eq"/>
</filter>
</link-entity>
</entity>
</fetch>


What is the correct process to show quote details with quote products in custom report?

Thanks

*This post is locked for comments

I have the same question (0)
  • Rajkumar Rajaraman Profile Picture
    on at

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
JS-09031509-0 Profile Picture

JS-09031509-0 3

#3
Ciprian  P Profile Picture

Ciprian P 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans