Post reply

Different images in one cell based on a condition.

  • October 17, 2008 at 4:51 am

    #199881

    IN REPORTING SERVICES:

    I want to display one of 5 different images in a cell in a report

    based on the different values obtained in a column in the table. :hehe:

    Thanks.

  • October 17, 2008 at 5:01 am

    #886258

    This may help:

    http://www.sqlservercentral.com/Forums/Topic580852-149-1.aspx#bm581005

  • October 17, 2008 at 5:15 am

    #886265

    hi,

    u can embbed your images into RS first. If u need to show images according to value then embedded images is the best solution. I had one project where i need to show images according to different values. Once u embed ur images, u can write expression on value of images. U can drag images to ur layout in ur body and write expression.

    Say u have one image of 5 called 'green'. U can have to show it according to some value total between 0 and 0.4 then u can write expression like below on value of image 'green'.

    =iif(Fields!total.Value >= 0.00

    and Fields!total.Value <= 0.40, "green")

    let me know if u find problem.

  • October 17, 2008 at 5:21 am

    #886267

    If it is at one place then make sure you put 5 images on top of each other.

  • October 17, 2008 at 6:28 am

    #886305

    yes.... This solution worked!

    Thanks:D

  • October 17, 2008 at 7:46 am

    #886361

    U dont believe but i have spent around 2-3 days to get this solution. I am glad it is helpful for you.

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

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