水晶报道:记录选择公式 [英] Crystal reports: record selection formula
问题描述
我正在尝试使用以下代码过滤掉数据:
{fg_rdtlh.upd-date}在日期(2018年,01,01)到日期(2018,01,31)和
not({E,C,A中的{fg_rdtlh.rita-code}])
所以基本上,如果日期不是2018年1月,而RITA代码是E,C或A,我想省略数据。
这是我要添加的内容,无法找到正确的语法。我想要另一个过滤器,说明RITA代码是否为T且fg_rdtlh.qty是否小于零,也省略。
有人可以帮助我吗?
我尝试过:
Crystal新手所以不确定如何处理
猜测,如:和({fg_rdtlh.rita-code}<>T或{fg_rdtlh.qty}> = 0)它可能是
!=
而不是<>
;我很久没有接触Crystal Reports了! :)
I'm trying to filter out data using the following code:
{fg_rdtlh.upd-date} in Date (2018, 01, 01) to Date (2018, 01, 31) and
not ({fg_rdtlh.rita-code} in ["E", "C", "A"])
So basicallly, if the date isn't in January 2018 and the RITA Code is an E, C, or A, I want to omit the data.
Here's what I want to add and can't find the correct syntax. I want another filter that says if the RITA code is "T" and fg_rdtlh.qty is less than zero, omit as well.
Can someone help me with that?
What I have tried:
New to Crystal so not sure how to handle
At a guess, something like:and ({fg_rdtlh.rita-code} <> "T" or {fg_rdtlh.qty} >= 0)It might be
!=
instead of<>
; I haven't had to touch Crystal Reports in a long time! :)
这篇关于水晶报道:记录选择公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!