DYNAMICS CRM ONLINE +SSRS REPORT returning empty report when adding some fields

0
30
Forum Post: Change the Filter On option on Opportunity Associated View for Account form


Hi,

I have created an SSRS report for Invoices in Dynamics 365 Online, It was working fine until I realized I missed one attribute of the linked entity, I added that attribute to fetch XML and tested the XML using, the XRM toolbox Fetch XML tester and it returned the desired value which I was looking for, But as I uploaded the report in CRM it is giving me a blank report which was not the Issue before.

That’s what kind of confuses me, If Fetch XML Tester is returning the value why doesn’t the Report. I would appreciate any kind help and guidance.

<fetch>
<entity name=”invoice” enableprefiltering=”1″>
<attribute name=”invoiceid” />
<attribute name=”shipto_line2″ />
<attribute name=”shipto_city” />
<attribute name=”billto_line2″ />
<attribute name=”sg_referencenumber” />
<attribute name=”shipto_stateorprovince” />
<attribute name=”billto_stateorprovince” />
<attribute name=”shipto_postalcode” />
<attribute name=”billto_city” />
<attribute name=”billto_line1″ />
<attribute name=”billto_line3″ />
<attribute name=”invoicenumber” />
<attribute name=”createdon” />
<attribute name=”billto_postalcode” />
<attribute name=”shipto_line3″ />
<attribute name=”shipto_line1″ />
<attribute name=”msdyn_invoicedate” />
<attribute name=”paymenttermscode” />
<attribute name=”sg_workorder” />
<attribute name=”freightamount” />
<attribute name=”totalamount” />
<attribute name=”totallineitemamount” />
<attribute name=”totaltax” />
<attribute name=”sg_salesperson” />
<attribute name=”billto_telephone” />
<attribute name=”shipto_telephone” />
<attribute name=”datedelivered” />
<attribute name=”description” />
<link-entity name=”invoicedetail” from=”invoiceid” to=”invoiceid” alias=”invoiceproduct”>
<attribute name=”productname” />
<attribute name=”invoiceid” />
<attribute name=”baseamount” />
<attribute name=”description” />
<attribute name=”priceperunit” />
<attribute name=”invoicedetailid” />
<attribute name=”quantity” />
</link-entity>
<link-entity name=”businessunit” from=”businessunitid” to=”owningbusinessunit” alias=”owner”>
<attribute name=”address1_line3″ />
<attribute name=”address1_line1″ />
<attribute name=”address1_city” />
<attribute name=”address1_stateorprovince” />
<attribute name=”address1_fax” />
<attribute name=”address1_postalcode” />
<attribute name=”address1_telephone1″ />
</link-entity>
<link-entity name=”account” from=”accountid” to=”customerid” alias=”mainacc”>
<attribute name=”name” />
<attribute name=”msdyn_billingaccount” />
<attribute name=”accountid” />
</link-entity>
<link-entity name=”account” from=”accountid” to=”sg_billingaccount” alias=”billing”>
<attribute name=”name” />
<attribute name=”accountnumber” />
<attribute name=”accountid” />
</link-entity>
<link-entity name=”account” from=”accountid” to=”sg_serviceaccount” alias=”service”>
<attribute name=”name” />
<attribute name=”accountnumber” />
<attribute name=”accountid” />
</link-entity>
</entity>
</fetch>

The attributes in red are added later in the report and that is why I am getting the blank report. I am trying to create an Invoice report and it’s returning me blank when I am trying to add Bill to and ship accounts

Thank you in advance



Source link

Leave a reply

Please enter your comment!
Please enter your name here