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.
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 reportsjust 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")- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
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")- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com
|
 |
|
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?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|