To combine two IIf statement in ssrs expression

Question

0.00/5 (No votes)

See more:

Hi
I am trying to combine two different IIF expressions as one. Is that possible by using "and"?? and I dont want to concatenate it. Any suggessions??

Posted 13-Dec-12 2:38am

Dhivya.J

Add a Solution

Comments

AmitGajjar 13-Dec-12 8:40am

what you mean by concatenate ?

Member 9581488 13-Dec-12 9:16am

You can try the following
=IIf(Parameters!MyField1.Value="Month" And Parameters!MyField2.Value="Sale",
Iif(Sum(Fields!Total.Value) = 0, "Zero sum", "Non-zero sum"),
"Test")

ZurdoDev 13-Dec-12 10:16am

You should post that as the solution. Good job.

Member 9581488 13-Dec-12 10:38am

Thank you!

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 9581488 · Answer 1 · 2012-12-13T04:37:00

Solution 2

You can try the following
=IIf(Parameters!MyField1.Value="Month" And Parameters!MyField2.Value="Sale",
Iif(Sum(Fields!Total.Value) = 0, "Zero sum", "Non-zero sum"),"Test")

Posted 13-Dec-12 4:37am

Member 9581488

v2

To combine two IIf statement in ssrs expression

1 solution

Solution 2

Add your solution here

Preview 0

To combine two IIf statement in ssrs expression

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us