Image on Job Traveler

[klincecum (Kevin Lincecum)]

Works fine but the client is complaining about an unterminated string.

[klincecum (Kevin Lincecum)]

Fixed that, client being dumb. Just add a post process on that same Method to clear the CallContextBPMData.Character01 →

callContextBpmData.Character01 = String.Empty;

No more complaints.

[tonyb1986 (Tony Burke)]

Just having some food, once sorted im going to give this a whirl, see what i can break!

[klincecum (Kevin Lincecum)]

Thing is, I bet that field is delimited and works with the mass print function.

If it is, we need to pull all the jobs, and pass down a json dictionary like I did before. Then you can pull by job.

[tonyb1986 (Tony Burke)]

@klincecum

//Ref: Erp.Contracts.BO.Image

CallService<ImageSvcContract>(img =>
{
    var job = Db.JobHead.FirstOrDefault(x => x.JobNum == ds.JobTravParam.FirstOrDefault().Jobs);
    
    if(job == null) return;
    
    byte[] image = img.GetOriginalImage(job.UserChar1);
    
    callContextBpmData.Character01 = Convert.ToBase64String(image);
});

i assume… this goes into method called CallContextBPMData based on the query expression below this

[klincecum (Kevin Lincecum)]

@tonyb1986

i assume…

@klincecum

Pre-Processing on Erp.Rpt.JobTrav.SubmitToAgent

…

[tonyb1986 (Tony Burke)]

sorry i knew the pre proccesing part i ment the actual name of the call

correct myself again! the Directive Name!

[klincecum (Kevin Lincecum)]

Name it whatever your heart desires.

[klincecum (Kevin Lincecum)]

Just got word from a friend, says it is probably tilde ~ separated.

So this won’t work as is for mass prints. I can help with that, but not right now.

All the info to do so is in this post and the technique demo post though.

[klincecum (Kevin Lincecum)]

Ignore everything I just said, because I am an idiot.

You can just join to the filestore table on the RDD.

[tonyb1986 (Tony Burke)]

i was just about to say if it wont work with mass print its not really much use to us and i was about to ask if i embed all 33 images it pulls through totally fine and i cant seem to see much performance drop in terms of time to generate the report.

PLUS these images are very very unlikely to change UNLESS we want to change the appearance slightly which may or may not happen

[klincecum (Kevin Lincecum)]

It would have worked. We would just had to modify it.

Oh well, this is better. Wish my brain had worked earlier lol.

Some of the techniques shown could be used for other purposes though, so not a total loss.

Happy Thanksgiving y’all!

[tonyb1986 (Tony Burke)]

thanks for all your help and to @kve! Happy Thanksgiving from the UK!

[tonyb1986 (Tony Burke)]

Ok apparently i dont know how to do this at all, will do some further reading, however…

Upon opening image maintenance and using the filed help i can see the images are stored on the image table and i can add the table at the RDD level fine, its added, why cant we just use this and then use the image filename from this table?

Or can we donit this way, would this not be even simpler again?

And as previously said i personally dont have the knowledge or experience…ssrs is a dark art

[Mark_Wonsil]

Maybe this thread will help you out.

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…

[kve (Kevin Veldman)]

@tonyb1986

ssrs is a dark art

[Randy (Randy Stulce)]

I’ve used the technique posted by @BenWheeldon to add images to reports.

Dynamic url logos in reports won't render all of the sudden

@aosemwengie1 I know these points do not help your current main issue, however hoping this will help you and others going forward. The current solution of Images assigned in Report Style does work for multi company. However you do need to go into the report style for each company to set the image. It is a little confusing in classic because the images section is on the same tab as the Company list, making it seem like you can just select the company from the list and hit retrieve. However it d…