How Do I put Leading Zeros in Crystal Report Amount Field?

[hyde42]

I'm trying to have an amount show up with the actual amount and right fill with zeros so that the field length is always 13...for example 42471 would show as 4247100000000. Right now, in my criteria I have the following: {StecLGC_PremiumValues.EffectiveFrom}<>{StecLGC_PremiumValues.EffectiveThru} and
{StecLGC_PremiumValues.AccountType} = "retiree ib"

How do I add the data for the amount? Thanks! h

 

[lbass]

Leading zeros means zeros on the left. If your really want them on the right, you could do this:

stringvar x := totext({table.number},0,"");
x + replicatestring("0",13-len(x))

-LB

 

[hyde42]

it's saying a boolean is required after my and statement from the previous line

 

[hyde42]

and it wants something after the last + sign like a number, currency amount, boolean, date, time, etc...

 

[lbass]

You should be creating this formula in the field explorer->formula->new. Please do that and then report back if you still have any errors. You would then use this formula instead of the original field on the report.

-LB

 

[hyde42]

it's asking for a boolean after the + sign

 

[kskid]

Post the formula.

 

[hyde42]

nevermind"...I got it! thanks! h