it can be done in BC using vs-code, also with a word report.
follow these steps:
1) copy the standard sales quote report, also the layout to a new custom report, set new object id and name, so that you can make the changes. save, compile, publish the extension. for that steps follow moxie4nav.wordpress.com/.../.
2) add variable TenantMedia: record "tenant media" to the global report variables
3) add new dataitem(Item;Item) after the last column of dataitem "Line" (Sales Line)
4) add the typical properties to connect the dataitems Line and Item via field "No."
5) add column(Picture;TenantMedia.Content) ... for showing the item picture in the line
6) in trigger onaftergetrecord add new variable Item: record item
at the end of the trigger code add:
item.get("no.")
if item.picture.count > 0 then begin
TenantMedia.get(Item.picture.item(1));
TenantMedia.CalcFields(Content);
remark:to load the picture data within the onaftergetrecord trigger in new dataitem "Item" won't work, the data is loaded to late to be shown in the line.
7) edit the word layout in vs-code using ms word, activate the developer tools menu in word, activate the xml structure to view the fields structure
8) add new column in the line table. set the column heading to "Picture", set the cursor into the new cell in the new column, add new field Header/Line/Item/Picture as Picture into the new cell. save the word report, close word, compile and publish the extension
