如果报告条件 [英] If condition in report
问题描述
我有一个textfeld的报告。
有3个值。其中只有一个不是空白(即大于0)。这个应显示在报告中。
我将其粘贴到文本字段的控制源中并获取:不带操作数的运算符。怎么回事?
= IIf([Limit]> 0,[Limit],IIf([StopLimit]> 0,[StopLimit],IIf([StopMarket]> 0 ,[StopMarket],")))
问候,
Aen
< blockquote>
我有一个textfeld的报告。
有3个值。其中只有一个不是空白(即大于0)。这个应显示在报告中。
我将其粘贴到文本字段的控制源中并获取:不带操作数的运算符。怎么回事?
= IIf([Limit]> 0,[Limit],IIf([StopLimit]> 0,[StopLimit],IIf([StopMarket]> 0 ,[StopMarket],")))
问候,
Aen
也许其中一个字段名称 - [Limit],[StopLimit]]或[StopMarket]与报告控件名称冲突?
也许其中一个字段名称 - [Limit],[StopLimit]]或[StopMarket]与报告控件名称冲突?
嘿,
很遗憾没有。
谢谢!
问候
尝试:
= IIf(len(nz([Limit]) )> 0,[Limit],IIf(len(nz([StopLimit]))> 0,[StopLimit],IIf(len(nz([StopMarket]))> 0,[StopMarket],"" ;)))
最后一个嵌套的IIF有效是不必要的,当总是填充一个:-)
Nic; o )
I have a report with a textfeld.
There are 3 values. Only one of them is NOT blank (i.e. bigger than 0) . This one should be displayed in the report.
I paste this in the control source of the textfield and get: "operator without operand". Whats wrong?
=IIf([Limit]>0,[Limit],IIf([StopLimit]>0,[StopLimit],IIf([StopMarket]>0,[StopMarket],"")))
regards,
Aen
I have a report with a textfeld.
There are 3 values. Only one of them is NOT blank (i.e. bigger than 0) . This one should be displayed in the report.
I paste this in the control source of the textfield and get: "operator without operand". Whats wrong?
=IIf([Limit]>0,[Limit],IIf([StopLimit]>0,[StopLimit],IIf([StopMarket]>0,[StopMarket],"")))
regards,
AenMaybe one of the field names - [Limit], [StopLimit]] or [StopMarket] collide with a report control name ?
Maybe one of the field names - [Limit], [StopLimit]] or [StopMarket] collide with a report control name ?hey,
unfortunately not.
thanks !
regards
Try:
=IIf(len(nz([Limit]))>0,[Limit],IIf(len(nz([StopLimit]))>0, [StopLimit],IIf(len(nz([StopMarket]))>0,[StopMarket],"")))
The last nested IIF effectively is unnecessary when always one is filled :-)
Nic;o)
这篇关于如果报告条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!