Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Expression with images

Author  Topic 

gavakie
Posting Yak Master

221 Posts

Posted - 2007-11-16 : 11:37:22
I have a report im building and in the header I need the image to change based off of what parameter they choose. Im trying to use a switch statement =switch(field.company_name.value = 1, "1.png, field.company_name.value = 2, "2.png", field.company_name.value = 2, "2.png") I cant get the image to come up right. Any help or other suggestions would be welcome.

tm
Posting Yak Master

160 Posts

Posted - 2007-11-23 : 10:53:01
Add your bitmaps to image item, embedded the images and in the Value property use something like ..
=IIF(var1=var0,"sunset","winter")

Where var1 is a field or value, var0 is a field or value, sunset and winter is bitmaps embedded into the image item.

You can do the same thing with Projects by using something like ..
=IIF(var1=var0,"sunset.jpg","winter.jpg")
Go to Top of Page
   

- Advertisement -