Dynamics Community Forum Thread Details

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

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

Quick Links

Subscribe to this forum!