How to show product images on product reports
Description
Add an image to a product from the Web tab of its record. You can also add product images to reports using your company data path. If you have multiple companies, save a separate report for each one.
Cause
Resolution

Check the path to your company data

  1. Select Help, then choose About.
  2. In the Program Details section, make a note of the Data Directory.
  3. Press OK.

Add the image from the product record to a document

  1. Select the document you want to amend, then select Edit.
  2. On the menu bar choose Report, select Report Properties.
  3. Enter a new report name and description, then press OK.
  4. Select the Details section, then in the Properties pane set the Height as 0.8500.
  5. Press Enter.
  6. On the menu bar, select Toolbox, then press Add Image / Logo.
  7. Select where you want the image to appear.
  8. Select Build an expression to select an image, then press OK.
  9. Enter the following expression: "Data path you noted earlier\\IMAGES\\"+ STOCK.WEB_IMAGE_FILE  

     

    When entering the data path, use \\ to separate the folders, for example:

    "C:\\ProgramData\\Sage\\Accounts\\2023\\company.000\\ACCDATA\\IMAGES\\" + STOCK.WEB_IMAGE_FILE

    If using an UNC path, use \\\\ at the beginning of the expression.

  10. Press OK.
  11. In the Properties pane, set the Size Method as Stretch.
  12. On the menu bar select File, press Save As.
  13. Enter a new file name then press Save.
  14. On the menu bar, select File, then press Exit.

NOTE:

Don’t use spaces in image filenames. Use an underscore "_" instead.

 

[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions