>>I use Memo field as header, I centered it as
>>
>> MyCafe Coffee Shop[Enter]
>> Hillcrest Mall[Enter]
>> Yonge Street[Enter]
>> Toronto[Enter]
>>
>>On the receipt, it will print as:
>>
>> MyCafe Coffee Shop
>> Hillcrest Mall
>> Yonge Street
>> Toronto
>>
>>But on the bill, I want it align as:
>>
>>MyCafe Coffee Shop
>>Hillcrest Mall
>>Yonge Street
>>Toronto
>>
>>Is that possible?
>
>I don't think you can do that in the report itself, but in the code that puts the data together, use ALINES() to bring the memo into individual lines, ALLTRIM() each one and put them back together.
>
>Tamar
@Jerry,
Aside what Tamar said, regexp might do in a single step, or an UDF called from the report that does the ALINES and
LTRIM conversion. The regexp might work from the frx as well, if clever initialised.
Note. Such stuff is not recommended inside the frx
sheet, since any processing in the frx often run many times, while outside only one time. You can do one time in frx's data environment, or before calling the frx at all.
Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]