Case statement in SSRS

Question

Can some one please tell me how to re-write the below case statement in SSRS?

CASE
WHEN ACTUAL_PERFOMANCE_MIN_BECHMARK > 0
THEN ACTUAL_PERFOMANCE_MIN_BECHMARK * 500
ELSE
CASE
WHEN ACTUAL_PERFOMANCE_TARGET_BECHMARK < 0>THEN ACTUAL_PERFOMANCE_TARGET_BECHMARK * 300
ELSE 0
END
END

Anil Mer · Accepted Answer

SSRS Case statement is basically one of the widely used program flow statements. It allows us to control the program flow and it’s output when we have more than two flows/conditions to set. In other words, a case statement is an optimized version of a nested If statement.

SSRS Case statement is a decision function that can be reached through expressions. Keyword for case statements in SSRS is Switch, and not case like in other similar technologies.

Syntax for case statement in SSRS:

  Switch(Expression as Object)

You can either use Nested IIF or Switch

Example for Switch

Switch(Fields!ActualPerformanceMinBenchmark.Value>500,Fields!ActualPerformanceMinBenchmark.Value*500,Fields!ActualPerformanceTargetBenchmark.Value 0, Fields!ActualPerformanceMinBenchmark.Value*500,iif(Fields!ActualPerformanceTargetBenchmark.Value

Helen Allison · Answer

space waves msn is a game that keeps me motivated to improve every day. You should play it because it's both exciting and satisfying.

Case statement in SSRS

About this question

Your answer

2 Answers

More Salesforce discussions

Learn & Explore

Salesforce Tutorials

Salesforce Interview Q&A

Latest Salesforce Blogs

Want answers to more Salesforce questions?

Stay in the loop — it’s free

You’re on the list!