111111 0 XXXXXXXX,XXXXXX /FONT
1 PER REG 11 02APR10 [U]PAST MATURITY DATE 02APR10 WITH BALANCE 654.70-[/U][/B] /FONT
222222 1096 YYYYYYYY,YYYYYYYYY /FONT
I have a report which I extract the reason and this field could wrap to the next line and it is left justified, so I defined the field (starting at column 43 and being 83 characters long) with the Advanced Field On[/B] set to End of left Justification[/B]. What I find odd is that for the member 111111, the data in the reason field has all the spaces as in the report, but for member 222222 it seems to squeeze all the duplicate spaces into one when it finds that the line is wrapping.
So this is what I get with my template fields:
/codeIs this normal behaviour?
I have another field that is simply used to display the field as a different name (different language actually) and this field was also defined as 83 characters long; it's formula is quite simply the template field (Reason). What is interesting is that the calculated field works fine if the data is from data that was on a single line, but if it got the data from multiple lines, it seems to truncate the field even though there is enough room in the 83 characters to completely display it. To get it to display the entire field, I have to define it larger then the initial template field. Here is what I mean:
As you can see, member 222222 has the contents reduced to 63 characters even though it can hold 83. I suspect that it still takes in consideration the original spaces that were in the report but somehow got removed. When I increase the calculated field to be 113 I get it to display the whole thing.
Is this a bug?