Wednesday, June 29, 2011

Creating new report running on specific record

When creating reports in Microsoft Dynamics Crm 2011 Using fetchMXL is required.
Creating reports with fetchXML could make life easier, Like when creating *contextual reports. It can be done by adding enableprefiltering="true"  attribute to entity tag.

Example:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="invoice" enableprefiltering="true">
<attribute name="name" />
<attribute name="customerid" />
<attribute name="totalamount" />
<attribute name="invoiceid" />
<order attribute="name" descending="false" />
</entity>
</fetch>




*Running report on specific record and not on all the record, like in quote report.

No comments:

Post a Comment