Images In RMS Report

Can't be done.

You might be able to do it in Crystal Reports, or if you switch to SQL

2005 you may be able to do it in Reporting Services - I'm not sure on either of those, but may be possible...

You can definately do it with HTML or ASP. Take a look at the drilldown.htm file in the ...\Store Operations\HTML directory. This is is intended to be launched from a Custom POS Button and uses QSBridge & QSRules to access the database, but it should help you get started.

Glenn Adams Tiber Creek C> Im trying to display the image for every product in my inventory on a report.

If you figure it out, let me know. I've been trying to get this report for months. The best I could get it to do was to modify the report to show the name of the image with the location string, export the report to HTML, modify the tags (using find & replace) to be proper HTML with notepad, then open the new HTML report with a browser. It won't work directly because the export process strips out the quotes needed for HTML. Certainly not ideal, but I am not an ASP programmer, and it's what I could manage myself. Good luck!

I was in your shoes about 2 months ago doing the EXACT same thing.

I came up with Crystal Report or using Excel. Excel was the cheapest and easiest solution for this. What I did is this;

1) Name all the pictures of my items xxx.jpg(where 'xxx' is the itemlookupcode). 2) Then in my Store or HQ Admin I did "update item set picturename itemlookupcode + '.jpg';" To set all the picturenames for all the items(my company has 10,000+ items). 3) Now put all the items in the HQ/Store Ops Picture folder. 4) Next you can use VB scripts to display pictures. 5) Use CONCATENATE() in excel to dynamicly create a path to display the picture.

I've taken this even farther to VLOOKUP other reports or link in an 'External Data Source' to get more information about the item from the database it's self.

I'd be more then happy to send you this Excel doc with the VB Script if you need it. Note the ONLY downside from doing this in excel is that if your pictures aren't boxy or square shaped... meaning that they are for example 300 x 50 or 100 x 600, then Excel mite not be your ticket. Most of the Excel VB Image functions that I've found will load images and resize them to a dimension that you provide. So i do 125 x 125 and all my images get resized to this. Afterword you can go back and retouch them to get the right dimensions.

Hope this helps.