ZIP code was printed as number with dicimal Separators

[christiey]

The data type of zip code in our Oracle databse 8i is number. In Crystal reports 8.5, I customized the number field to remove the decimal and thousands separators from File\Options\Fields\Number\Number\Customize. I can run the report directly with correct zip code format. But when I used VB 6 (with RDC) to export the external crystal report as PDF format, it back to default format and print the zip code with decimal and thousand separators. Is there any way I can keep the customized format using VB to export an external Crystal Reports? The ZIP code is part of a formula which concatenates City, State and Zip code together. Any help is really appreciated!!!

 

[synapsevampire]

A quick cheat would be to convert it to a text field:

totext({MyTable.MyZip},0)

and

Check for patches at

http://www.crystaldecisions.com,

they update the exports fairly often.

and

You might also change the default number format used by CR and see if that helps:

File->Options->Fields->Number

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Perhaps alter that to:

totext({MyTable.MyZip},0,"&quot

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[christiey]

It works, thanks a lot!