Crystal Reports- How to print City,State, Zip in one line?

Hi,

I am using the following formula to print City, State, and Zip in a single line.

Trim ({tblInvoiceRpt.City})+", "+Trim ({tblInvoiceRpt.State})+" - " +
ToText({tblInvoiceRpt.Zip})


The result I get is -

Moorseville, NC - 45,677.00

The Zip code is displayed with decimal places. How to rectify this? Please help.

Thanks,
Ruvi

Why are you storing Zip code as a numeric? It should be stored as text in the database (as and example in nNH the zips all start with 0 (zero) so Dover NH is 03820. IF stored as a numeric then you wold store 3820 which is not the correct zip).

I believe it is

Code:

---

ToText({tblInvoiceRpt.Zip}, 0, "")

---

no decimals, and no formatting

Thank u ppl,

As per ur suggestion, I am storing zip code as text in the database

Ruvi