本文介绍了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问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-22 19:47