Concatenate Crystal

Question

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

I have these two fields in dataset. How can I concatenate these in cryatal report to display as alise name(REF_NO)?

send me solution pls

Answer 1

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.