Hi all,
here is the problem: how can I print item pictures (jpeg files) in the SLS invoice report? I am aware that in the Board the question has already been discussed, but I can't find the right solution. I mean I have to print a picture whenever an item line is printed (not only the company logo). Can somebody help me?

Thanks in advance.

Hi,

one possible way (not for faint hearted!) is to export invoice data as XML and use Crystal Reports to generate the final report by merging pictures stored in a MS Access Database.

Pure phantasy? Not really! some time ago I did a quick proof of concept implementation. See attached pdf file.

I have just seen the attached file: it's exactly what I have to do!Unfortunately I can't use Crystal Reports (or at least it is not installed by the BaaN customer) so what can I do to merge the BaaN report and the pictures? Why do you convert the report to XML? Can you give me more detailed information?
Thank you.

I am not sure how feasible this is - but can you create some html file with links to the jpg? Create a new report from the old. Embed whatever html code you need - like <IMG SRC="image1.jpg" width="367" height="266">. Then maybe take this file and create a pdf. Just a guess.

Another option could be to convert the SLS Invoice report to HTML format. Store all the images on a shared drive (to which all users have access). You can also store the images with file names as the item code, so that u don't have to hard code the values, u can use the item code to get the image name as well.
Then in the report, include the image from this drive. always use a web browser to open your report. this way, the report will include the images & the user can print that through the web browser.

We tried this with a couple of reports & it worked.

One way to do this is to take the report output to Ms-Word using a utility like B2Win or directly using ttstpconv with RTF format. Once in Ms-Word, you can write a macro in Visual Basic to include the Pictures in the document you just created.

For PDF, some txt2pdf tools allow you to add pictures easily to text.

In both cases, you can automate printing from within your script

I hope this helps.