Hi there select name,thumbnail_location,description from products where deleted <> '1' sql returns shoe,http://mysite/thumbs/shoe1.jpg shirt,http://mysite/thumbs/shirt1.jpg when I add this to ireport I get the location of the thumb as in sql, but i want to pull in the actual jpeg and not the location next to the product in my report. every product has its own image.