Display a String with 0 supressed

[luminous1975]

I need to display a stirng with Zero's not to be seen
for eg if the actual value of the string in the db is

0000031534 it should display
31534 on the report

not necessary the no of zeros wud be the same
it might also be less like this

0000314566 in which case it shud display
314566 on the report

Pls help

 

[kskid]

In Cruystal 8.5, I can use the ToNumber function

ToNumber({table.field}}


ToNumber("00123.45") returns 123.45

 

[synapsevampire]

You can use 2 means that come to mind:

val({table.field})

or you can keep it as a string:

totext(val({table.field}),0,"")

-k