使用具有空条件的水晶报表选择记录

本文介绍了使用具有空条件的水晶报表选择记录的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我试图在我的水晶报表中使用以下公式过滤数据库中的数据，其中一个条件是即使这样也包含数据，{vw_CandidateProfile.Type}"为空或空字符串.但是下面的公式不起作用.有什么想法吗?

I was trying to filter the data in database with the following formula in my crystal report and one of the condition is to included the data even this, '{vw_CandidateProfile.Type}' is null or empty string. But the formula below doesn't work. Any ideas?

{vw_CandidateProfile.Candidate_Code} = '881225095228' AND ( {vw_CandidateProfile.Type} IN ['NGO','EDU','PRS','PPR','PPS','TTL','OTH'] OR ISNULL({vw_CandidateProfile.Type}) )

推荐答案

我找到了解决方案，其中 IsNull() 字段必须位于非 IsNull() 字段之前.

I have found the solution in which the IsNull() field has to comes before the field which is no IsNull().

{vw_CandidateProfile.Type} IN ['NGO','EDU','PRS','PPR','PPS','TTL','OTH'] OR ISNULL({vw_CandidateProfile.Type})

变成

ISNULL({vw_CandidateProfile.Type}) OR {vw_CandidateProfile.Type} IN ['NGO','EDU','PRS','PPR','PPS','TTL','OTH']