Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Custom Report Current Record Sub-Report not showing data

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • RE: Custom Report Current Record Sub-Report not showing data

    Refer this:

    www.powerobjects.com/.../dynamics-crm-sub-report-not-displaying

    social.microsoft.com/.../dynamics-crm-custom-quote-ssrs-report-fetchxml

    Hope this helps.

    Regards,

    R.Rajkumar

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans