本文介绍了IsNothing的嵌套IIF问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
水晶(工作正常)
Crystal (is working fine)
if isnull({rptTrainingBillingInfo.OrderPrice}) then
(
if isnull({rptTrainingBillingInfo.BillingRecordPrice}) then
{rptTrainingBillingInfo.ItemPrice}
else
{rptTrainingBillingInfo.BillingRecordPrice}
)
else
(
{rptTrainingBillingInfo.OrderPrice}
)
报告服务
Reporting Services
=IIF (IsNothing(Fields!OrderPrice.Value),
IIF (IsNothing(Fields!BillingRecordPrice.Value), Fields!ItemPrice.Value, Fields!BillingRecordPrice.Value),
Fields!OrderPrice.Value)
出于某些奇怪的原因,SSRS中的第二个IIF在评估时始终为0!
如果我只是评估第二个IIF,我会得到一个值
For some strange reason, the second IIF in SSRS when evaluating is given 0 always!
if I just evaluate the second IIF, I get a value
IIF (IsNothing(Fields!BillingRecordPrice.Value),Fields!ItemPrice.Value, Fields!BillingRecordPrice.Value)
但是,如果我同时嵌套两个IFF,则不会.
任何的想法?谢谢
But if I nested both IFF I don''t.
Any idea? Thanks
推荐答案
=IIF (IsNothing(Fields!OrderPriceNatural.Value), 1, 2)
如果在期望的1位置看到2,则说明问题不是由嵌套的IIF引起的.
If you see 2 where you expected 1 then the problem is not caused by the nested IIF.
这篇关于IsNothing的嵌套IIF问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!