如何用Reporting Services表达式语言编写if else语句? [英] How do I write an if else statement in Reporting Services expression language?
本文介绍了如何用Reporting Services表达式语言编写if else语句?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想写一个Reporting Services "Expression"
,基本上表现如下(伪代码)...
I would like to write a Reporting Services "Expression"
that basically behaves as the following (pseudo code)...
if ([Fields!StateProvinceId.Value] == 1)
{
return "Ontario";
}
else if ([Fields!StateProvinceId.Value] == 2)
{
return "Quebec";
}
else if ([Fields!StateProvinceId.Value] == 3)
{
return "Manitoba";
}
// ...
// more cases same pattern
我看不到这种逻辑,我是否必须嵌套一堆IIF?
I don't see this type of logic do I have to nest a bunch of IIF?
=IIF(Fields!StateProvinceId.Value = 1, "Ontario", IIF(Fields!StateProvinceId.Value = 2, "Quebec", IFF(Fields!StateProvinceId.Value = 3, "Manitoba", "Unknown Province")))
推荐答案
您是否尝试过switch语句?
Have you tried a switch statement?
= Switch( Fields!StateProvinceId.value=1,"Ontario", Fields!StateProvinceId.value=2,"Quebec", Fields!StateProvinceId.value=3,"Manitoba")
例如,请参见本页上的决策功能":
See "decision functions" on this page for example:
http://msdn.microsoft.com/en-us/library/ms157328.aspx
这篇关于如何用Reporting Services表达式语言编写if else语句?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文