Scientific Notation

[IanStrange]

Hi
I am using crystal 9 and have brought in one of our pallet reference numbers which is a long string of numbers and we need this in it excact form but crystal 9 keeps converting it to scientific notation any one know a way to stop it or convert it back
Thanks

No man is an island but 6 tied together make quite a good raft.

 

[pgtek]

Hi
converting your filed to text

pg

 

[IanStrange]

Nope that just makes it a text version of the scientific notation.

No man is an island but 6 tied together make quite a good raft.

 

[dgillz]

Converting to text doesn't do it. It will show the same format, and be left aligned instead of right alighed, as the default behavior of a text field.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

I just tested this with a 36-digit number and it seems to work, where the number of x's = the number of digits in your field:

picture({table.palletreferenceno},"xxxxxxxxxxxxxxxxxxxxxxx&quot

-LB

 

[IanStrange]

Again this does not work. I will explain a bit more.
I am importing data from an xml using crystal 9's new xml stuff. one of the fields is a 11 digit figure. And no matter what I do it always comes in 1.23e+17. Could it be the odbc driver changing it?

No man is an island but 6 tied together make quite a good raft.