Hi, I wanted to display an image on my harddrive in the report.(I am using SSRS SQL 2008) I wanted to know is this possible. Basically I have a sales order with a few items in it what i am trying to acomplish is tht the image of the item is displayed besides each Item in the sales order. Any help is appreciated Thanks a lot
The image files need to be available to the report server, either uploaded as part of the project or at an HTTP location that is under your control. Simply add an image object from the toolbox and drop it onto the report designer space in BIDS and then set the properties of the object to link to the image location. So long as your inventory has a predictable naming convention you can store the image locations in your database and set the image properties to be the value from the database, therefore making sure the image relates to the item detailed in the report
This is more of a web programming question, I would have thought. However, the basic concept is as follows: - Create a website with the images that you wish to share - For each item that you wish to display, either return the complete <IMG> tag for the image, or enough of the URL for the report to be able to provide the rest - do the appropriate formatting bits to make that bit of code render as HTML rather than text.
Guys - can someone else sort out the fiddly bits? I've just crawled in having been on the road for 5 hours, and need curry and beer, and the library is in the car!