使用空条件的水晶报表选择记录 [英] Select records using crystal report with null condition

问题描述

我试图在我的水晶报表中使用以下公式过滤数据库中的数据，条件之一是即使包含数据， {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'] 

这篇关于使用空条件的水晶报表选择记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！