user2218469
user2218469

Reputation: 21

Concatenate string and numeric field in crystal report

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

Upvotes: 2

Views: 20801

Answers (1)

CoSpringsGuy
CoSpringsGuy

Reputation: 1645

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

Upvotes: 5

Related Questions