在水晶报表中获取空字段 [英] Getting null fields in crystal reports

问题描述

我有一个客户名称，包括名字，姓氏，中间名。我想连接这些字段。当我连接这些字段时，我得到一些字段为空因为它包含至少一个空值字段。我已尝试此公式。

I have a customer name with first name, last name, middle name. I want to concatenate these fields. When I concatenate these fields I am getting some of the fields as null cause as it contains at least one null value field. I have tried with this formula.

{FIRST_NAME}&","&{MIDDLE_NAME}&","&{LAST_NAME}

例如：我有名字，中间名为空，将整个字段设置为null。
请帮我解决这个问题。

Ex: I have first name, last name but middle name is null then I am getting entire field as null. Please help me how to resolve this.

推荐答案

你可能想用一个公式包装每个字段调整 null s：

You'll probably want to wrap each field with a formula to adjust for nulls:

// {@FIRST_NAME}
If Isnull({table.FIRST_NAME}) Then "" Else {table.FIRST_NAME}

创建公式以连接它们

// {@FULL_NAME}
{@FIRST_NAME} + "," + {@MIDDLE_NAME} + "," + {@LAST_NAME}

这篇关于在水晶报表中获取空字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！