Adding Part Images to the Job Traveler

[Hbormann (Hannah)]

Hello. I am currently attempting to add part images into our Job Traveler. I have been messing around with Report Data Definition and Report Style Maintenance for days on end now and seem to be getting nowhere.

I’ve uploaded a couple of test photos to part records in Part Maintenance… that part was simple. However, I can’t seem to get the relationships between tables correct or tie it to the actual Job Traveler to display the image.

We’re using an older version of Epicor… 10.2.600.11, and this seems to cause the setup to be different than that of other threads I’ve seen regarding this.

I guess my question is, has anyone done this and know how to get the result I’m looking for?

[chaddb (Chadd Blanchard)]

We are doing something similar but on our quote form. We show an image of the part. We aren’t storing the image in Epicor. We pull the image from a network path. We store the base path in a UD field on plant.

[Mark_Wonsil]

@Hbormann

We’re using an older version of Epicor… 10.2.600.11, and this seems to cause the setup to be different than that of other threads I’ve seen regarding this.

Did it with 10.2.500. I think this is the thread:

Printing site logo on forms

@Hogardy had a post that describes this. Basically, the table that stores the images is called Ice.FileStore. [image] Notice the index to the table is the SysRowID and not a file name. So there’s another table called Erp.Image. [image] This table contains information about the image file in the image store. The ImageSysRowID in Image links to the FileStore record. So in your RDD, you need to have an ImageID to get to your Image record. (Make sure to include the necessary fields below in t…

It shows how to add the Part Image in the RDD.

[Hbormann (Hannah)]

This is wonderful! I will test this as soon as I can,

This may be a silly question… I have never had to edit an already existing report. Once I get to the part where I add an image to the report, and set the MIME type, where do I do this? I see a lot of talk about Microsoft Report Builder or Visual Studio. Must I do it with one of these?

[Mark_Wonsil]

Yes, I use Report Builder but you can use Visual Studio or even a text editor if you’re brave enough since they are just XML files.

[Hbormann (Hannah)]

On to the next hurdle… I’ve got the report customized, however when I want to test print Epicor just thinks and can’t identify a printer. I’m wondering if this has something to do with my file path? Here is what I have:

And here is my file path on my computer:

I’m not sure what I’m doing wrong here? I tried having our plant manager upload this to our Epicor server but that did not seem to work either! I can’t imagine what else would be preventing Epicor from identifying the report and allowing a print/print preview…

[klincecum (Kevin Lincecum)]

See if you can preview it.

[leonardpothier]

It needs to be in the SSRS directory that is identified in the report location. You need to upload it there through SSRS, not just as a file on your computer or server.

[Hbormann (Hannah)]

Okay I see… How do you do this? I’ve never heard of the SSRS directory so I’m not sure where to look or even what I’m looking for?

[leonardpothier]

You have to navigate to it in a web browser, it will likely be something like:

https://*SERVERNAME.DOMAIN*/Reports/browse/

This will be dependent on how your SSRS instance was setup and from there you would need to navigate to the instance and then the folder structure you have. You can then upload the report into the appropriate folder.

I’m not sure what Epicor version you are on but I know at some point they introduced the ability to upload through the Epicor UI but I’ve never done it that way, being on prem I get to hide under my rock and continue to do things the old/manual way.