Crystal Reports Padding a string to be the same length

Message

   Hi all- 

I am trying to create a formula for a cross tab that has two data fields in it (both strings) in CR 2008.

it looks like this;

{Vmin.MinAbbr}+'  '+({Vmin.MinName})

I have to use a cross tab with both fields in the same formula, if I use two cross tabs, one for each field the MinName drops off of the report because although the MinAbbr is always different the MinName can be the same.

Example data is

VOCA1 VOCATION
VOCA2 VOCATION
VOCA133 VOCATION

As you can see when the length of the MinAbbr changes the lineup of the second column goes wacky.

I need to be able to pad the MinAbbr field in the foruma so it's always the same length (say 14 characters) so the second column MinName always lines up left justified as well. Making my data look like this

VOCA1        VOCATION
VOCA2        VOCATION
VOCA133    VOCATION

I tried using the Space function and several other ways but I can't seem to get it to work.

Does this make any sense? Sorry for the long explanation and thanks in advance for any help you might have.

Rob

Edited by dimsrobert - 09 Apr 2009 at 3:55pm