I'm developing SSRS Report to show pictures attached in the Notes of an Account Entity. The environment is Dynamics 365 Online. I have used fetchxml to retrieve the images from Notes.
It is working fine if the attached picture size is less than 40KB. If the image size is bigger than 40/60KB, then the image is not displayed in the report.
If I embed the bigger size image directly in the SSRS Report, then SSRS displaying the image properly. So, It looks as the problem of FetchXML returning image data partially.
Is there any return data size limit for FetchXML?
Fetch XML used to test this.
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="annotation">
<attribute name="documentbody" />
<attribute name="mimetype" />
<attribute name="subject" />
<attribute name="notetext" />
<attribute name="filename" />
<filter type="and">
<condition attribute="isdocument" operator="eq" value="1" />
</filter>
<link-entity name="account" from="accountid" to="objectid" alias="account" link-type="inner">
<filter type="and">
<condition attribute="name" operator="eq" value="Image Test" />
</filter>
</link-entity>
</entity>
</fetch>
If I inspect the report window, I can find the images displayed properly having the tags with Reserved.ReportViewerWebControl.axd, but the images not displayed are having tags as <img> with gif type.
Appreciate your inputs to resolve this issue or find workaround to display big size images attached to the Notes in Dynamics 365 Online SSRS Reports.
Note: In the Visual Studio Preview, all the images are displayed properly. Only on Dynamics 365 Online, it is not working.
