Concatenate string and numeric field in crystal report

Question

I want to concatenate city and pincode field in crystal report. I have tried:

{datafield1.city}&"-"&{datafield2.pin}

It is displaying ex: Mangalore-568,757.00

But I want mangalore-568757

p.s.w.g · Accepted Answer · 2013-03-28 16:48:25Z

5

{datafield1.city}&"-"&totext({datafield2.pin},"#")

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

answered Mar 28, 2013 at 16:31

CoSpringsGuy

1,6451 gold badge14 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

To add to this answer, the "#" is the format string for the text conversion.