# Signature on PO **URL:** \ **Category:** Epicor ERP 10\ **Tags:** ssrs\ **Created:** [October 11, 2019, 2:24pm UTC](https://www.epiusers.help/t/signature-on-po/60719 "2019-10-11T14:24:03Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [October 11, 2019, 2:24pm UTC](https://www.epiusers.help/t/signature-on-po/60719/1 "2019-10-11T14:24:03Z")
Is anyone populating Buyer Signatures on the PO form? I did it in E9 and Crystal but not sure how to do it in E10 or SSRS. thanks Kim ---
**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\ **Post date:** [October 11, 2019, 2:54pm UTC](https://www.epiusers.help/t/signature-on-po/60719/2 "2019-10-11T14:54:24Z")
How did you populate it in E9? You should be able to do the same thing, so I’m curious what process you chose. ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [October 11, 2019, 3:00pm UTC](https://www.epiusers.help/t/signature-on-po/60719/3 "2019-10-11T15:00:34Z")
We did an Insert OLE Object on the Crsytal Report form and there was code to pull the correct Buyer Signature. Not sure how to translate that to SSRS. ---
**Author:** ![Jason\_Woods](https://www.epiusers.help/user_avatar/www.epiusers.help/jason_woods/32/80101_2.png) [@Jason\_Woods](https://www.epiusers.help/u/Jason_Woods)\ **Post date:** [October 11, 2019, 3:31pm UTC](https://www.epiusers.help/t/signature-on-po/60719/4 "2019-10-11T15:31:49Z")
If you have a bunch of images of the signature, you can place all of them on the SSRS and show the one associated with the buyer. It is a little backward from what you’d expect, but in the Visible section you would set the Hidden property to compare `BuyerID <> "jwoods"` ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [October 11, 2019, 3:50pm UTC](https://www.epiusers.help/t/signature-on-po/60719/5 "2019-10-11T15:50:35Z")
Or set the path of the image, using an expression. There’s even an option to pull the source from the DB (assuming they’re stored in the DB): ---
**Author:** ![Kimberley](https://www.epiusers.help/user_avatar/www.epiusers.help/kimberley/32/50847_2.png) [@Kimberley](https://www.epiusers.help/u/Kimberley)\ **Post date:** [October 11, 2019, 5:35pm UTC](https://www.epiusers.help/t/signature-on-po/60719/6 "2019-10-11T17:35:50Z")
I would think pulling the image. They are not stored in the DB. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [October 11, 2019, 5:40pm UTC](https://www.epiusers.help/t/signature-on-po/60719/7 "2019-10-11T17:40:28Z")
FWIW - I had a hell of a time trying to get an image field to use an expression to reference a file on the SSRS server. In fact, I was never able to reference it as a file. I ended up having to store them in the SSRS reports DB. When selecting “External” as the source, the only option you have to select the file is one that is stored in SSRS. I was able to upload 2 image files to the `reprorts` folder, using the browser interface ![image](https://epiusers.help/uploads/default/original/3X/9/b/9b26d1b3d8709cd6f9bfd4b086fbd80a36199b2f.png) ![image](https://epiusers.help/uploads/default/original/3X/e/2/e24bda33806be67e318c12362be02f46350a84e5.png) When you select a “file”, the value in the “Use this image:” field isn’t a string. ![image](https://epiusers.help/uploads/default/original/3X/f/4/f49d07eb172e995885cff0820444bad8ed45be69.png) But you can change it to ![image](https://epiusers.help/uploads/default/original/3X/4/3/43a692dfc41ca4b6ae1b9255d15314c685038f6e.png) and get: ![image](https://epiusers.help/uploads/default/original/3X/e/3/e39564accdbfdd26e00bd46579d8a2820f7124cb.png) ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [October 11, 2019, 5:47pm UTC](https://www.epiusers.help/t/signature-on-po/60719/8 "2019-10-11T17:47:10Z")
In addition you can add to @ckrusen post You can also add Custom Code to hide the signature if image doesnt exist (so you dont see the red x) – by right clicking on the Gray background on a Report and clicking Report Properties and then there is a Code section to add “Global/Shared” Code. ![image](https://epiusers.help/uploads/default/original/3X/4/d/4d1de3a55c71a8e3ee311f45f31fa0f8496b944f.png) ```auto Public Function CheckFileExists(FileName as string) as Boolean If System.IO.File.Exists(FileName) Then Return True Else Return False End If End Function ``` And then you can use the expression below to set the visibility of the textbox which contain the image. ```auto =IIF( Code.CheckFileExists(YourFilePath),false,true) ``` Just Remember the SSRS Service Account needs to be able to read the UNC Path where you store images. ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [October 11, 2019, 5:53pm UTC](https://www.epiusers.help/t/signature-on-po/60719/9 "2019-10-11T17:53:20Z")
Any Idea how to reference a file on a server? I tried all I could think of (like `="file:\\usdatdbs00001\c$\EpicorPicts\" + Fields!BuyerID.Value + ".png"`) but they all come up blank. It’s almost like the source being “External” means it wants to be a “file” IN the SSRS db. ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [October 11, 2019, 5:54pm UTC](https://www.epiusers.help/t/signature-on-po/60719/10 "2019-10-11T17:54:55Z")
Try 3 forward ```auto file:/// or file://\\MYUNC\c$\path ``` But I think it works for me without file… I just have to make sure the SSRS Account has access to read from that path. Typically using c$ requires elevation / a special account 🙂 with power ---
**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\ **Post date:** [October 11, 2019, 6:07pm UTC](https://www.epiusers.help/t/signature-on-po/60719/11 "2019-10-11T18:07:45Z")
I should have been clearer… The following works (notice lack of equals sign or quotes): `file:\\usdatdbs00001\c$\EpicorPicts\ckrusen.png` While none of the following work: - `="file:\\usdatdbs00001\c$\EpicorPicts\ckrusen.png"` - `="file:\\\\usdatdbs00001\\c$\\EpicorPicts\\ckrusen.png"` - `="file://\\usdatdbs00001\c$\EpicorPicts\ckrusen.png"` So as soon as I try to make it an expression (so I could eventually combine it with a dataset field), it breaks. Edit: I also tried (without any luck) - `file:\\usdatdbs00001\c$\EpicorPicts\+Fields!BuyerID.Value+.png` - `file:\\usdatdbs00001\c$\EpicorPicts\&Fields!BuyerID.Value&.png` - `file:\\usdatdbs00001\c$\EpicorPicts\Fields!BuyerID.Value.png` Is it a bad assumption that SSRS has access to the file location, just because `file:\\usdatdbs00001\c$\EpicorPicts\ckrusen.png` works?