Case statement in SSRS
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
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