We want to create a report with item mages and send the report via a busines event. The report would have a customer’s prior item purchases with the each item’s image from the item’s “attributes”. Is there a way in the same report to have an item’s description, the item’s purchase history, and the the item’s image from item attributes in the same report?
Best answer by dougmcbride79
View original
Hey
This should print the image to the report if the images is a properly formatted image type. See below.
** As long as you tie the InventoryItem table from the originating Sales Order/Line table on the report you create or use exiting, the image should be available for the item. If you select an existing report in the system to use, the InventoryItem table may already be added in the Table Relations. Such as the Sales Order Details by Customer (SO611000) report.
Hey
It sounds like there are a few different processes here (Report, Business Event, Notification Template). I’ll pass along some info to assist with the Report. You can then add the report as an “Attached Report” to the Email Template that gets triggered by the Business Event.
________
You will need to add the InventoryItem.ImageURL value Picture Box to either the newly created report or use an existing report.
To add the Stock Item picture to the report, you will 1. first make sure the InventoryItem table is correctly related to/from an existing table on the report. Once this is done, you can 2. create the new Picture Box, 3. assign the Source as Database, and 4. assign the Value as InventoryItem.ImageURL.
Assuming the Report is created correctly and the image is available, the Stock Item photo should appear on the report. See the below example I have added to the default report Sales Order Details by Customer (SO611000).
Thank you so much. I greatly appreciate your detailed directions to create a report with item images.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.