views:

1046

answers:

1

Hi,

I have a field in my report that needs to have a length of 40. If the string is not of that length I need to append some space.

Thanks.

+1  A: 

try something along the lines of

if length({yourfieldname here}) < 40 then {yourfieldnamehere} + space(40 - length({yourfieldnamehere})) else {yourfieldnamehere}

should point out that that goes in the formula for a formula field you define yourself lol!