I need direction to bring a product image from Image Maintenance into an SSRS report. In the BAQ, I can link the Part table to the Image table to reference the Image File Name. But how do I actually get the image to display in the report?
Has any one accomplished this yet?
Thanks,
Gina
Insert an image field, and then set its properties to use the dataset field containing the path, as the source location.
Might need to experiment with the path required. URL, vs drive letter, etc…
If you are on Premise you can create a view in your reporting database to reference the ice.filestore table. Then you can join to the view in the RDL and bring in the image. If you are cloud I"m not sure how you would go about accomplishing this since BAQ does not allow you to add a VarBinary datatype field. I saw a thread earlier where they said perhaps change the image to string in the BAQ and then convert it back to VarBinary in the RDL.