Image Files

Epicor ERP 10
1

Does any one now how I can get the image that is stored in epicor to print on BAQ Report or Data Definition Report?

Thanks,
Rick Hagy

2

Use below query to extract image Content in binary format , Drag Ice.FileStore.Content column in your report design

SELECT F.Content AS ImageFile, *
FROM Erp.IMAGE I
INNER JOIN Ice.FileStore F ON I.COMPANY = F.COMPANY
AND I.ImageSysRowID = F.SysRowID
WHERE I.COMPANY = ‘000’