Post reply

Adding multiple images to an SSRS report from website

  • October 4, 2008 at 12:00 am

    #198935

    Hello,

    I'm trying to build a retail best seller report and have it contain images. I basically have the report grouped by departments with a list of the top 20 best selling items (each row would have item number, description, qty sold, retail dollar, and *hopefully* the image to that item). The way I would need to pull the images would be from an internal website. The format for each item would be something like http://www.domain.com/products/image_ITEMNUMBER.jpg, where ITEMNUMBER would obviously be item number of the product. The URL will be static except for the item number. Is this possible? Any ideas on how to do this?

    I'm pretty new to SSRS and report writing so any help is appreciated.

    Thanks,

    Jared

  • October 10, 2008 at 10:12 am

    #883530

    This can be done, check the following link out...

    http://blogs.msdn.com/tudortr

  • October 10, 2008 at 1:05 pm

    #883611

    Thanks for the response. However, I'm not sure I know which section I should be looking at on your link.

  • October 11, 2008 at 3:32 am

    #883735

    hi,

    i m not sure it will hep for what you are looking for. But it will be helpful for any kind of images work and graphs.

    http://www.ssw.com.au/Ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx

    I have used it a lot for my reports.

    regards,

    vijay

  • October 21, 2008 at 6:41 am

    #887554

    Does the image have to be in your solution? Or can you do this on the fly?

  • October 21, 2008 at 1:24 pm

    #887806

    Either works.

    I was thinking the columns of the report would be like this:

    Item#, Item Description, Retail info (units, cost, retail), then the picture.

    For the picture I would just like to be able to pull from an internal web site and the format of the images is currently: http://www.domain.com/images/%5BFIRST_3_digits_of_Item#%5D/constant_ITEM#_constant.jpg.

    I'm basically trying to create a "Top Seller" report and have the pictures of the items on the report.

    You got some ideas?

  • October 22, 2008 at 10:22 am

    #888211

    Try these basic steps:

    This can work if you can store the url (not the image) in a database:

    1. Add an image control to your layout.

    2. When the wizard appears, select "Web" as the image source and click finish

    3. With the image control still selected, go to the properties and set the Sizing to "Fit" and the Value to the field in your database such as "=Fields!PIC_URL.Value"

    The value within the PIC_URL field could be "http://www.domain.com/products/image_ .jpg" that is dynamically populated based on your query of the top N items.

    By the way, you may get a warning message in BIDS (Visual Studio) referring to configuring the Unattended Execution Account. Check out this link regarding how to configure:

    http://technet.microsoft.com/en-us/library/ms156302.aspx

    Hope that helps,

    Pete

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply