Question:

How to insert product image in Invoice report?


Answer:

1) To design the report, you may click on Print and click on 'Design Report' button on the right side. Click on 'Design' at the report that you would like to amend.






2) Drag and increase the spacing for InvoiceDetail.




3) Then, drag out the 'Rich Text' from the left panel and place on the report.




4) Then click on the Expressions icon (symbol 'f') and click on the ellipsis (...) at Visible.




5) It will prompt Expression Editor, key in !IsNullOrEmpty([ProductEntity.Image]) at the Expression Editor then click on OK.




6) Then go to Html and click on the ellipsis (...).




7) It will also prompt Expression Editor, key in '<img src="' + [ProductEntity.Image] + '" style="height: 100px; width: 100px">', at the Expression Editor then click on OK.




8) After done, click the Menu on the top left and Save As and rename to new report as the original system Report name is not allowed to amend and save.






9) Result when you print preview for the report.





By: Aimi 240115, Lay Swan 240124, P240129