Numbers not displaying properly in crystal 8.5

[tsjd]

I'm facing a problem with crystal report 8.5 where the fields are unable to display the full range of numbers. The field which I am pulling data out from has 18 digits 221922000000000002 which is an account code. What i'm getting out of crystal when I display is 1.11e+017 which makes me unable to pull cross reference this data in order to fulfill other criterias. Anyone has any idea to display the whole number rather than the scientific value?

 

[Madawc]

Try ToText({your.data})



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Try a SQL expression, if it is available to you:

{fn CONVERT({table.`acctno`,SQL_VARCHAR)}

This worked when I tested it.

-LB

 

[tsjd]

thanks guys, lbass, where in particular do you put that statement? so, lets say the field name within the table (e.g. glpost) is drilldown i should type {fn CONVERT({glpost.drilldown,SQL_VARCHAR)} ?

 

[synapsevampire]

A SQL Expression is dependent upon your database type and connectivity, which you should always post.

You can use the actual database syntax as well, which I prefer.

I think that in CR 8.5 you used Insert->SQL Expression, but in any version you can right click SQL Expressions in the field explorer and select new.

Again, database/connectivity dependent.

-k