我希望根据参数过滤1组记录 . 但是,我仍然希望包括其他组 . 这就是我现在所处的选择专家:

{name_full.NAMETYPE} = "a" and
(if {GENERIC.GROUPTAG} in ["A","B","C","D","E","F","G","H","I","J","K","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"] OR
{GENERIC.GROUPTAG} = "L" and
{MEMBERSHIP_FULL.MEMBTYPE} = "IALS" and
{SUBSCRIPTIONLEVEL_FULL.SUBLTYPE} = "life" THEN TRUE)

必须有更好/更有效的方法来做到这一点,但我不知所措 .

我正在使用Crystal Reports XI和Oracle DB .