Attach images on the fly for SSRS reporting

Epicor ERP 10
1

Hi,

I’m generating a .png graphic in the configurator and saving it to temporary storage.

I need to include it on an SSRS report. We won’t be having the users go to Image Maintenance and loading each one, so getting to the stored file is an issue.

Has anyone done something like this on the fly?

Thanks,

Joe

1 Like
2

I’ve done BPMs on the configurator update that would take the generated drawing files and attach them to the quote record. I did it by calling the attachment BO methods to create the attachments.

Jim Rogers

1 Like
3

Jim,

Thanks for the direction!

You wouldn’t have an example handy, would you?

Joe

4

Jim,

I’m uncertain then how the attachment to the quote shows up on the SSRS report. Could you expand on this?

Thank you,
Karen

5

Karen,

My BPM was simply putting the attachment within the system. In order to print the attachment with the report, there are several methods to accomplish that. I believe Epicor is now marketing one that dotNetIT created in the past. Also the new integration with docStar would allow this functionality.

Jim

6

I’m not familiar with Configurator, but is the path of the stored image being stored somewhere on the database? If not, is the file name unique and ties back to the record by some key?

If so then this should work nicely.

7

In theory, you could call the Image Maintenance BO from a User Defined Method in the Configurator and create a unique image name (key) that you can save back to the order and/or quote line. This would then put the image in Ice.FileStore, which you could stream into an SSRS report. I have done this using native SQL but never with an RDD, etc. in the middle.

8

Thanks Jim. We are going to begin emailing our RFQ’s to our suppliers. I have written the code to email the report and email the drawing to each supplier. RFQ’s required heavy customizing on our part.

Karen