fields aligned in columns on subreport caption

[mrlyman]

I have an on-demand subreport and I'm useing the On-demand Supreport Caption. I'm trying to get the data pieces to appear in columns. I've posted my code below, the problem is that field 3 will not align.

Ex.
04/01/2012 Suzie Queue Mary Mayham
05/15/2012 Michael Stanoslaws Ralph Rescue
06/10/2012 Carol Coscoski Paul Dune

What am I missing.....? The max size of user is 30.

Space(41) + ToText({Date}),"MM/dd/YYYY"+
Space(25-len(Trim(ToText({Date},"MM/dd/yyyy"))))+
{user}+
Space(34-len({user}))+
{originator}

Thanks for looking!

 

[hilfy]

If I understand you correctly, the headers are not lining up with the columns underneath them. Is that correct? The issue is probably due to the fact that the font is proportional. This means that the width of each character is not standard. You can verify whether this is the issue by changing the font to a non-proportional font such as Courier New to see whether that resolves the issue.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[mrlyman]

Bingo! That resolved the issue. Thanks, hilfy for pointing the way.