Tuesday, October 27, 2015

AX 2012 :SSRS reports

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 >

IF statement :

=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

Table browser URL in D365FO

Critical Thinking icon icon by Icons8