SSRS Conditional Statements
Assign these expressions under background image properties of a textbox or any other control.
if not please assign these expressions under : text box properties > background image > value >
=IIF(Fields!Id.Value > 0 AND (Parameters!LOC.Value = "1" OR Parameters!LOC.Value = "2"),"TNlogo",
IIF(Fields!Id.Value > 0 AND Parameters!LOC.Value = "3","Officelogo",""))
same expression in Switch statement:
=switch(Fields!Id.Value > 0 AND (Parameters!LOC.Value = "1" OR Parameters!LOC.Value = "2"),"TNlogo",
Fields!Id.Value > 0 AND Parameters!LOC.Value = "3","Officelogo")
No comments:
Post a Comment