crystal formula

[needmoremoney]

I'm having a problem. Below is the statement.

whileprintingrecords;
numbervar currlength := length(totext({temp401KReport.currEePreTax}*100,"000000000"));
stringvar ContAmt := totext({temp401KReport.currEePreTax}*100,"000000000");

The number comes up 000000000 or 000000034 and -000000005.
I need to limit the output to only nine characters even if there is a negative number.

Any help thanks..

 

[synapsevampire]

So you do or do not want to show the negative number?

Why not post what you need rather than what isn't correct?

Anyway, try using a conditional on each using the brute force method:

whileprintingrecords;
if {temp401KReport.currEePreTax} < 0 then
stringvar ContAmt := totext({temp401KReport.currEePreTax}*100,"00000000")
else
stringvar ContAmt := totext({temp401KReport.currEePreTax}*100,"000000000");

-k

 

[needmoremoney]

Hello,

Thanks a million, that worked.

Onemore thing though. Should I stick with the stringvar ContAmt or the numbervar currlength?