Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
So, you’re building a custom SSRS report using FetchXML and you have the requirement to display images from Notes in Dynamics 365.
(If you need some initial setup assistance, see one of our previous blogs, Quotes: How to Display an Image Stored in Dynamics 365 on an SSRS Report, for help.)
Now, fast forward to deploying and testing your report within Dynamics 365. If everything looks great except the images didn’t render properly, you’re probably thinking, “What the heck?!” Perhaps you see a little red X, maybe the image is only half-loaded or pixelated, or it could be a combination of these. Regardless, it’s frustrating! Here are a few potential quick solutions for image rendering issues that may be just what you need…
1. Review the header of your FetchXML behind the dataset bringing those images into the report: is distinct=”true” in there? If so, this is likely the source of your image rendering problem. Set it to false or, better yet, simply remove the whole condition if you don’t need it.
2. When it comes to rendering images nicely, Dynamics 365 has a size limit of 75 KB. It might render an image over 75 KB, but it won’t like doing it and it you probably won’t like the results! As a safeguard against inadvertently attempting to display an image that exceeds the limit, consider adding a Row Visibility expression to hide an image greater than 75 KB. For example: =IIF(Fields!NOTE_filesize.Value/1024 > 75, True, False) where this would be Set expression for: Hidden.
3. Another solution is to avoid this size limitation altogether by reducing the size of your images within Dynamics 365. Now, there is no way to reduce the size of the original image that is added, but you can trigger a plugin that makes a copy of the image and reduces its size in the process. Most likely, your images are attachments onto Notes, and your plugin can have a logic flow like this:
IF Note contains an image attachment
IF image file size < configurable max value
– Reduce the quality by configurable percentage and shrink the image (maintaining scale) so the largest side matches the configurable value; repeat if still too big
– Replace original image with newly reduced image
This, along with collaboration of your Row Visibility expression from #2 above, will prevent those big, unwanted images from trying to render and display in your report.
Hopefully these solution(s) help clear up some image rendering issues. Be sure to subscribe to our blog for more Dynamics 365 tips and tricks!
Business Applications communities