连接两个字段 [英] Concatenate two fields

问题描述

我在数据集中有这两个字段。如何在水晶报表中将它们连接显示在一起？

  select 
 CAST（T.GLTR_PSTNG_TYPE AS VARCHAR）REF_NO，
 CAST（T.GLTR_DOC_CODE AS VARCHAR）GLTR_OUR_DOC_NO 
来自dom 
  

，右键点击公式字段并选择新建

。

它会提示您输入公式名称。

在公式工作室屏幕中，选择您需要从 >数据源，将其向下拖动到编辑部分。公式应如下所示：

  {YourDataSource.Field1}& & {YourDataSource.Field2} 
  

点击保存并关闭。

现在，您可以将公式字段拖到报表上查看。

I have these two fields in a dataset. How can I concatenate these in Crystal Reports to display next to each other?

select 
  CAST(T.GLTR_PSTNG_TYPE AS VARCHAR) REF_NO, 
  CAST(T.GLTR_DOC_CODE AS VARCHAR) GLTR_OUR_DOC_NO    
from dom

解决方案

You will need to create a FORMULA to concatenate these strings.

In the Field Explorer , right click the Formula Fields and select New.

It will prompt you for a Formula Name. Enter the name of your choice, and hit enter.

In the Formula Workshop screen select the 2 fields you require to concat from the Datasource, drag them down to the edit section. The formula should look something like this

{YourDataSource.Field1} & " " & {YourDataSource.Field2}

Click Save and Close.

Now you can drag the Formula Field onto the report to view.

这篇关于连接两个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！