Employee Badges - Can I show imported images in SSRS

Epicor ERP 10
1

I would like to print Employee badges using SSRS and V10.1. The images are imported into Epicor somewhere but I can’t find them.

I see there is an Erp.Image table that holds the Picture properties i.e. size, file type, etc. but the actual picture is not in that table.

Does anyone know where pictures are stored after being imported?

Thanks,
DaveO
Ph: 651-246-3281

2

If you know the ID of your image you can use Image.BO to return the image
GetOriginalImage with imageID parameter set to “YourImageID”

<tracePacket>
  <businessObject>Erp.Proxy.BO.ImageImpl</businessObject>
  <methodName>GetOriginalImage</methodName>
  <appServerUri>net.tcp://jpe10prod/E10LiveDB2/</appServerUri>
  <returnType>System.Byte[]</returnType>
  <localTime>12/28/2016 15:45:25:6937032 PM</localTime>
  <executionTime>197</executionTime>
  <parameters>
    <parameter name="imageID" type="System.String"><![CDATA[eye]]></parameter>
  </parameters>
</tracePacket>
3

Mr. Chris: Thanks for the reply - but I would like to display the images in an SSRS report - I’m not sure how I would get at a BO from within SSRS.

DaveO

4

Dave,

Fairly easy if you have your photo’s stored in a single location.

  1. Build your table of employees.
  2. Make sure your table has EmpBasic.PhotoFile
  3. Add a column
  4. Insert an image.
  5. Set it to External
  6. Use this image with the expression [=“FILE:\SERVER\PHOTOFOLDER” + Fields!PhotoFile.Value + “.BMP”]

Also, if you have your photos stored in AD you can also use that using a different method.

Edit: site is removing a \ from the end of File:… there should be 2
Edit 2: If I were to use employee photos in Epicor I would be storing them in the \Server\EpicorData\EmpPhoto folder.

5

Mr. Dan: Thank you for the suggestion. I am doing what you suggested for earlier version of Epicor. However the V10.1 has us importing the images. They may have the same name and I could keep the images in two places, however that becomes a maintenance head ache having to make sure if I rename a picture in my Share drive then I have to remember to delete and reimport the image into Epicor to keep things in sync.

When you import an image into Epicor - the image must be stored somewhere. Any clues?

Thanks,
DaveO

6

Sorry, I didn’t realize they embedded the images in 10.1.
Once again this is very easy/maybe easier.

  1. Build your table of employees.
  2. Make sure your table has EmpBasic.IMAGEID <-- instead of photofile
  3. Join Ice.FileStore to Erp.Image to EmpBasic through Company/ImageID (There may be a better way of join this through other tables)
  4. Add a column
  5. Insert an image.
  6. Set it to EMBEDDED
  7. Use this image with =Ice.FileStore.Content field.
  8. Make an expression to use Erp.Image.FileType for your MIME.
7

FYI:
as of 10.1.500.x, the table that stores the images (ice.filestore) cannot be included in an RDD, so a separate data source would have to be created within the SSRS report that points to the Epicor database (or a replicated copy of the Epicor database would be even better) to get at that table in the interim. The ability to successfully include the ice.filestore table in an RDD is targeted to 10.2.

1 Like
8

Mr. Nathan: Thank you for pointing me to the Ice.Filestore - I will give that a try.

DaveO