Excel export problem

[aky1234]

Hi, Im using Crystal reports 10 , When I export a report to excel 97-2000, especially for the zip code field which is a string , a square box appears at the end of the data , what could be the reason?

Thanks
aky

 

[synapsevampire]

Perhaps there's an extraneous character on the end, but apply the service pack to begin with:

http://support.businessobjects.com/fix/samplescr.asp

Then you might try checking for extraneous characters, or placing constraints on the length of the data:

left({table.zip},5)

-k

 

[aky1234]

Thank You, it was an extraneous charecter in the database

 

[khartman]

Have you checked to see if there is a carriage return or line feed at teh end of the zip-code entry? I have found that this is generally what the character is.

Kenneth Hartman
Manager, EIS
Hughes Network Systems

http://www.hns.com