Line or a value 1

[Senseial]

Hello All

I have a small problem. I have a field that is a number.
I need to print a value if the value exists directly from a database (not a problem if the value does not exist I have to print a line (_________) ???
What is the best way and most efficient to do this.

Thanks a lot

 

[lbass]

You could use:

if isnull({table.number}) then "______" else
totext({table.number},0,"")

-LB

 

[Senseial]

You know that field is a type NUMBER. How can I put a line in a number field?

Thanks

 

[tektipdjango]

LBass means you have to create a formula field!

But if you're in CR9 version you can simply go in the format field >>> general >>> in the bottom there is a 'text' button and enter in it the formula

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​

 

[lbass]

The formula above converts the number field to text. Since the results of a formula have to be of the same datatype, if you want one of the results to be a line created as a string, then the number field must also be converted to a string.

-LB

 

[Senseial]

Thanks LB.