我在进行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)
谢谢