Adding Blank Spaces to a formula field Conditionally 1

[kime1974]

I am using Crystal 8.5 and need to fill a field (LastName) with blank spaces if the length is less than 30. Example:

If my last name is Jones, I need the formula to add 25 blank spaces after it for when I export my report. If my last name is Simmons I need the formula to add 23 blank spaces, etc.

Thanks!

 

[lbass]

You can add spaces by using a formula like this:

{table.name}+space(30-len({table.name}))

You would have to use a nonproportional font like Courier New. I can't guarantee how this would export though.

-LB

 

[kime1974]

Perfect! Thanks!