Joining fields of different data types

[harrietohs]

I have crystal ver 8.5.
I want to create a unique field by joining an Activity Number, which looks like A03-004567, to a Sequence Number, which looks like 01,02,03, etc. (In other words, each distinct Activity can have multiple sequences.)

I tried this formula:
{activity.activity_no}+TOTEXT({activity.activity_seq})

but it returns all the sequence numbers as 00.

Can someone help with correct formula?

Thanks

 

[pgtek]

hi
create a group on your activity number
and just insert your sequence number

or

insert a text box

and place the activity number in it and add a space and insert the suence number inside also

pgtek

 

[harrietohs]

I should have explained that my ultimate goal is to create a cross tab that does a distinct count of each set of Activity Number+ Sequence Number. So, I need to do this via a formula?

 

[lbass]

Are you sure you are not misinterpreting added decimals as the returned sequence number? You might want to try:

{activity.activity_no}+TOTEXT({activity.activity_seq},0,"&quot

You could add in a hyphen or a space between elements to clarify what's being returned.

Also, you can use "&" instead of "+" and then you do not need to convert the sequence number to text. The "&" allows you to concatenate fields of different data types without the need for conversion.

-LB

 

[harrietohs]

Mea Culpa! Yes, I was not seeing the returned data for what it really was, and I only picked up on the .00! Duh. But I am happy to have learned about using the & to work with different data types.

Thanks so much.