Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

How to make my RDL report in Dynamics 365 to run "only" for selected record

(1) ShareShare
ReportReport
Posted on by 1

Hey, 
I have created a new report using SSDT, and I am trying to make it run only for selected record but it won't



I added parameters the Lease entity is fine and it's filtered based on Invoiceid but Invoice table it self will never get filtered

Default Value for CRM_FilteredInvoice parameter is
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"><entity name="invoice"><all-attributes/></entity></fetch>



and this is default value for InvoiceId parameter




<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="new_lease">
    <attribute name="new_leaseid" />
    <attribute name="new_name" />
    <attribute name="createdon" />
    <attribute name="new_invoice" />
    <order attribute="new_name" descending="false" />
    <filter type="and">
      <condition attribute="new_invoice" operator="eq" uitype="invoice" value="@InvoiceId" />
    </filter>
  </entity>
</fetch>


------

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="invoice" enableprefiltering="100" prefilterparametername="CRM_FilteredInvoice">
    <attribute name="name" />
    <attribute name="customerid" />
    <attribute name="totalamount" />
    <attribute name="invoiceid" />
    <attribute name="new_title" />
    <attribute name="new_reference" />
    <attribute name="modifiedon" />
    <attribute name="new_lease" />
    <attribute name="invoicenumber" />
    <attribute name="new_bankaccountdetail" />
    <attribute name="new_note" />
    <attribute name="new_totalamountpaid" />
    <attribute name="new_remainingamount" />
    <attribute name="freightamount" />
    <attribute name="discountpercentage" />
    <attribute name="discountamount" />
    <attribute name="totallineitemamount" />
    <attribute name="new_invoicedate" />
    <attribute name="totalamountlessfreight" />
    <attribute name="new_renewaldate" />
    <attribute name="new_iqdexchangerate" />
    <attribute name="new_dinar" />
    <attribute name="new_iqd_input" />
  </entity>
</fetch>


the related column between them is new_invoice the value it take is "invoiceId" value

 

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans