IIF (conditional expression) in SSRS report

(0) Share

Report

Posted on by Community Member

Please note that this report's design has tablix and on the tablix there are rectangles.

SSRS report with RDP class and temp table. I'm trying to hide fields in different rectangles. Let me know if I'm doing anything wrong or any error in expressions. Thanks!!

Logic:

If brake type is "Thruster Brake" then hide Coil Brake rectangle and Hyraulic Brake rectangle.

Expression :

=IIF((First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Coil Brake" & "Hydraulic Brake"), false, true)

Pink color rectangle

Logic:

If brake type is "Coil Brake" then hide Thruster brake and hydraulic brake

Expression:

=IIF((First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Thruster Brake" & "Hydraulic Brake"), false, true)

Blue color rectangle

Logic:

If brake type is "Hydraulic brake" then hide Thruster brake and Coil Brake.

Expression:

=IIF((First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Thruster Brake" & "Coil Brake"), false, true)

Running AX 2012 R3 with Visual Studio 2010.

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Suggested answer

Anton Venter 20,656 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, the part that doesn't make sense is in bold below. The field value cannot be both values.

=IIF((First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Coil Brake" & "Hydraulic Brake"), false, true)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Replace "&" with "AND" in your expression.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi all,

Thanks for your kind suggestions. I'm still having trouble. I've 3 groups on the a tablix.

These 3 groups have a parameter called brake type. If parameter brake type = X then make group 1 visible & group 2 and 3 invisible. Any expression where this scenario is possible? Also, what about the black space of invisible groups once the logic is triggered. Any help will be greatly appreciated. I can also provide screen shots if needed. Please let me know.

Thank you!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi!! you can try:

=IIF((First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Thruster Brake" Or First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Coil Brake"), false, true)

one cuestion, why use first? is only one cell or columns?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Roberto,

Tried this and it didn't work. However, if I break this expression into two separate ones and place them into separate rectangles or groups then it works but it still doesn't make any sense. It hides both of them. My goal is to hide only one or the other. I'm thinking about writing classes that might manipulate this logic. Any suggestions?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi, I feel confuse with your question and your code...

Logic:

If brake type is "Thruster Brake" then hide Coil Brake rectangle and Hyraulic Brake rectangle.

Expression :

=IIF((First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Coil Brake" & "Hydraulic Brake"), false, true)

You need to hide Coil Brake and Hyraulic Brake if Brake Type is "Thruster Brake", but in your code, you didn't check "Thruster Brake". Is it should be something like this??

=IIF((First(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable") = "Thruster Brake"), false, true)

And then put this code in both Coil Brake rectangle and Hyraulic Brake rectangle??

PS: Please note "false" mean visible, "true" mean hidden.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

What if I want to hide Coil brake and make other two visible? How do I write OrElse expression in this case? I'm a newbie in developing SSRS reports.

Thank you!

Was this reply helpful? Yes No
Martin Dráb 239,036 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It's easier than you think, because you're trying to add things that shouldn't be there.

Write an expression for each of these controls individually and set Hidden to Fields!Mag_BrakeTypes.Value = "Mag_BrakeTable" or Fields!Mag_BrakeTypes.Value <> "Mag_BrakeTable", depending on the required behavior.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

How do I write two expressions together? Does this make any sense? Please help.

=IIF(Fields!Mag_BrakeTypes.Value, "Mag_BrakeTabe") = "Coil Brake") and Fields!Mag_BrakeTypes.Value, "Mag_BrakeTable" = "Hydraulic Brake"), false, true)

Thanks!

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Please refer to following expressions:

Thruster rectangle

=IIF((Fields!Mag_BrakeTypes.Value = "Coil Brake" OR Fields!Mag_BrakeTypes.Value = "Hydraulic Brake"), false, true)

Coil rectangle

=IIF((Fields!Mag_BrakeTypes.Value = "Thruster Brake" OR Fields!Mag_BrakeTypes.Value = "Hydraulic Brake"), false, true)

Hydraulic rectangle

=IIF((Fields!Mag_BrakeTypes.Value = "Coil Brake" OR Fields!Mag_BrakeTypes.Value = "Thruster Brake"), false, true)

This is super weird. It hides all 3 rectangles. I'm not sure what I'm doing wrong. Any help will be greatly appreciated!

Thank you!

Was this reply helpful? Yes No