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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dynamic Image

Author  Topic 

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2010-11-29 : 02:03:14
Hi,
Iam using SSRS2008 r2 Version for developing some warehouse reports

just i need an help in image properties,Based on user login the logo
should get displayed...if suppose userid is user1 then first.jpg should get displayed if userid is user2 then second.jpg should get displayed and so on..

how this can be done?


Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-11-29 : 04:26:29
I assume you have some logic in your dataset query that determines which image should be displayed? In that case just create an expression in the image properties dialog:


The expression would look something like this:
=iif (Fields!ColumnName.Value = "1", "image1.jpg", "image2.jpg")

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2010-11-29 : 05:08:52
thank for your reply Mr.Lumbago.how the same came to done if i have more that 10-15 reports.i planned to store in table and call the image..is this work?

quote:
Originally posted by Lumbago

I assume you have some logic in your dataset query that determines which image should be displayed? In that case just create an expression in the image properties dialog:


The expression would look something like this:
=iif (Fields!ColumnName.Value = "1", "image1.jpg", "image2.jpg")

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com


Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-11-29 : 05:17:55
Maybe you can create the image as a report of its own and call it in the 10-15 reports as a sub-report with a parameter saying which image should be displayed?

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page
   

- Advertisement -