How to combine Database fields label together in crystal report

Hi I am working in .Net crystal reports with asp2.0 and VS2010, now what i want is i have fou开发者_JAVA百科r fields, drag and dropped, AddressName, AddressCity, AddressZip etc, now i have placed their labels and they repeat, what i want is, one label should have AddressName,AddressCity,AddressZip combined, like 507 Eden Towers Main Boulevard Gulberg, Lahore 54000. And also, i dont want separate fields to be combined as they overlap on lengthy record, i want one label with everything related to address binded.

Please help

---

You can just create a new formula field, and in that formula concatenate your fields together:

{YourTableName.AddressName} + " " + {YourTableName.AddressCity} + ", " + {YourTableName.AddressZip} 

Then, instead of the AddressName, AddressCity and AddressZip fields, put your new formula field on the report instead.

---

You can also create a text label and drag any report field in the label. That way, the text is actually concatenated and you won't have any spacing problems.