Fixed it. Thanks Calvin!!!
1 Like
Thank you for this. My issue to render the image on another Epicor Form (e.g. Job, etc) how could I accomplish this?
Hi,
I want to rise this topic again. Maybe someone already built baq and ssrs on cloud, where you can get part image from attributes. I have tried to add BPM in BAQ as @josecgomez suggested but still trying to add loop while ttResults does not exist and ds allso(Last image). If i will be success(I hope), the question is how to set immage on SSRS, I mean it need to set MIME on SSRS and set “Use this field” with calculated field value? Maybe anyone can share some screen shots. Epicor consultants helped use to do that with MtlTags, but they say that it is impossible with BAQ reports.
Solve the case, so I will share with screenshots, maybe it will be useful for someone. For the base script thanks to EXPERT @josecgomez
So you need:
-
Create BAQ:
-
Create empty calculated field as NVARCHAR
3.Make baq updatable, go to advaced BPM section, on GetList create PostProcessing and add custom code:
foreach(var y in result.Results) //UBAQ results
{
var arr= (from x in Db.FileStore.With(LockHint.NoLock) where x.FileName == y.Part_ImageID && x.Company == y.Part_Company select x.Content).FirstOrDefault(); //Get image content
if(arr!=null)
y.Calculated_calc = Convert.ToBase64String(arr); //Convert content to string
}
4.if you test baq you shoud see that calculated field empty but it actualy carries hudge data, you can check that by copying in like MSWord
-
then create your BAQ report and on SSRS add immage and set fields:
-
and thats it, the result is:
6 Likes
Whoaa ! nice trick!
I would have never thought about using UBAQ abilities…
Thanks MR Gomez !!! 
Will definitly use it!
But seriously… Epicor should have thought of that, (being able to use the image into a report…) when they introduced this image feature… 
Can also be done in the RDD.
Printing site logo on forms - ERP 10 - Epicor User Help Forum (epiusers.help)
2 Likes
Thanks Mark,
I will have to test that one… but it seems a better way…
Pierre
I didn’t follow the whole thread, but you can do this with vanilla SSRS, stored procedures, and exposing the images on IIS for internal consumption. In my case, I store the photos in a very specific schema and then parse it to match as a string on a UD table record and then query for it inside my stored procedure:
This returns a URL in the data. Then in the SSRS report, I use an image and point it to the URL specified in the data.
2 Likes
Little late here, but the way I have always done it is just by adding the image and filestore tables to the report data definition, along with the necessary relations. Then you can just add the field to the SSRS query, and bind it to your report as usual…
2 Likes
@Justas is there any way you can show me the Update General Properties and Update Processing settings? This is my first time making an updatable BAQ and I feel like i have something wrong. I cannot test the BAQ on the analyze tab at the moment. Here are screen shots of what I have going on.
I did tried the same thing but not able to see image, its still blank for me
Mr. @dishant : Are you testing this as a BAQ Report? or an RDD Report.
I was not able to get the RDD Report to work with the UBAQ. However the BAQ Report did work for me.
DaveO
1 Like
I see…i was trying it via RDD BAQ…i tried it via BAQ report it did showed the image…Also i was trying this to add some functionality to link part images from shared folder instead of image maintenance
https://www.epiusers.help/t/images-from-alternate-storage-instead-of-db-blobs/107003
…but no luck in there to show images via that method on SSRS form(It did shows up on part attritubute )…any clue of what i may be missing? or is it that it needed to add images via image maintenance only instead of linking it.
Mr. @dishant: Sorry i do not know - hopefully someone here can chime in with a suggestion.
Glad to hear the BAQ Report is working.
DaveO
Just coming back with same testing, i can now use the RDD BAQ now, what i did is use the BPM and function from the below link:-
https://www.epiusers.help/t/images-from-alternate-storage-instead-of-db-blobs/107003
And adjusted the code to have file prefix with file: instead of file:> and made the base path to null, for me to add pic from multiple shared folder.
Than in BAQ i pull part table and use the below columns and make the imageID begins with file to show up that only data.
In SSRS form, i then use the external image source and select the part_imageID column, so SSRS form will pull the column name as an URL, which will shows up as image in SSRS form
2 Likes
Wow, I finally made something useful.
2 Likes