reporting-services之带 If 语句的 SSRS 表达式

我正在做有关 SSRS 报告的报告。如果提供，我需要为文本框编写一个表达式以显示不同的输入参数。我试过写这个表达式。却无法做到尽善尽美。在这里，我提供了示例代码，其中我需要一个 SSRS 表达式。谁能帮我提供相同的 SSRS 格式的表达式。

代码

If(Parameters!FromCreationdate.Value !=null && Parameters!ToCreationdate.Value !=null) 
{ 
  "Created Date:"+ Parameters!FromCreationdate.Value + "To Created Date:"+Parameters!ToCreationdate.Value; 
} 
else if(Parameters!FromCreationdate.Value !=null) 
{ 
  "Created Date:"+ Parameters!FromCreationdate.Value; 
} 
else if(Parameters!ToCreationdate.Value !=null) 
{ 
 "To Created Date:"+ Parameters!ToCreationdate.Value; 
} 

表达

=IIf(isnothing(Parameters!FromCreationdate.Value),"", "From Creation Date:"+Parameters!FromCreationdate.Value, iif(isnothing(Parameters!FromCreationdate.Value)),"", "To Creation Date:"+Parameters!FromCreationdate.Value) 

谢谢

请您参考如下方法:

看看Expression Examples (Report Builder and SSRS)更具体地说，在 SWITCH

The Switch function is useful when you have three or more conditions to test. The Switch function returns the value associated with the first expression in a series that evaluates to true

所以你会像这样使用它

=SWITCH( 
TEST_CONDITION_1,VALUE_1, 
TEST_CONDITION_2,VALUE_2, 
TEST_CONDITION_3,VALUE_3, 
.... 
TEST_CONDITION_N,VALUE_N 
)