Switch expression in SSRS

(0) Share

Report

Posted on by Community Member

Hi everyone,

When I have a report parameter which is a toggle on or off which meant to hide some rows, can I use a Switch expression in its Row groups Visibility property.

Something like this :

=Switch(

Parameters!DataSet1_inclDetailPaym.Value <> "Yes" and Fields!LineType.Value = "L2_Detail", True,

Parameters!DataSet1_inclOtherPaym.Value <> "Yes" and Fields!LineType.Value = "L3_Other", True,

Parameters!DataSet1_inclRefund.Value <> "Yes" and Fields!LineType.Value = "L4_Refund", True,

False)

So DataSet1_incl.... is my report parameter that toggle on or off, and that Fields!LineType is my field that chosen as the Row Groups. And in its Visibility property, I put the expression like the above. The intention is, when the parameter is off (No) and the current Field!LineType of the current row is the specific word, the row with that LineType is hidden (True), else is hidden = False

No error in that expression, but during run, it says something wrong with my report.

Need help.

Thanks

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report
Hi WWwong,

I think the problem is that "switch" statement doesn't have "else" option (or at least I don't see it)

Try to add True condition to the last row.

=Switch( Parameters!DataSet1_inclDetailPaym.Value <> "Yes" and Fields!LineType.Value = "L2_Detail", True, Parameters!DataSet1_inclOtherPaym.Value <> "Yes" and Fields!LineType.Value = "L3_Other", True, Parameters!DataSet1_inclRefund.Value <> "Yes" and Fields!LineType.Value = "L4_Refund", True, True, False)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sergei,

Isn't the last one is the "else", which I put as False, meaning it will show if not passed the previous condition ?

..and the expression is for the hidden, right? means if it is meet the condition it will set to True (hide it) else is False, show it.

unless I'm wrong..:)

Thanks,

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi WWwong,

Yes, for hidden expression True = Hide, False = Show.

But for Switch statement syntax is

SWITCH (

condition, result,

condition, result

)

And looks like there is no else (default) option, but you can try to workaround it by putting True as a condition to the last line

SWITCH (

condition, result,

condition, result,

True, result -- Else

)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sergei,

Thank you. Finally, It works. :)

Was this reply helpful? Yes No

Join the conversation

Community site session details

Switch expression in SSRS

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Switch expression in SSRS

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates