Hey,

I've got a question:

I've got a formula field. It's alignment is set to "right".
I want to print some dates, text, numbers ... with that formula field.
The formula looks like this:

{@Page_Number} + CHR(13)
+
Cstr({DatePrinted}, 'dd.MM.yyyy') + CHR(13)
+
(if (Length(Cstr(SupplierID})) > 0 ) then
Cstr(SupplierID}, '#') + CHR(13))
+
(if (Length(Cstr({CustomerID})) > 0 ) then
Cstr({CustomerID}) + CHR(13))

IMO the result must look like this:


Edited by crystallize - 25 Jan 2011 at 5:32am

Thx for your answer.
I already used "trim" but it changed nothing. Also I tried alot things in the "format editor" of that field.

Any other ideas?

Thank you.
I tried it with the textbox, but it's still the same result.

It's not PageNumber-Formula or the DatePrinted-Field. I replaced them with hardcoded data and it's the same result

Good morning,

I've tried the following:
First of all i created some formula fields (a formula-field for "{@Page_Number}" and a formula-field for  "Cstr({oSalesDocument_oSalesDocPrintedColl.dtDatePrinted}, 'dd.MM.yyyy')"
and so on.
Put them all into my report, same font/size and their alignment set to right.
Looks fine if I do it this way.

BUT the point is to get them all into one formula or even all formulas in the same textbox. The reason is, if I want to format them (change the font/size, position or other things I want to change only 1 field instead of 6).

Next try I've putted those formula-fields into a textbox...... ye, looks ugly again. Same problem.
I've tried trim, but it changed nothing.

*cry*

Edit:

I've just tried to put those formula-fields into a textbox again. But instead of putting them right into there under each other with a carriage return I've tried to set them in a row. Extended the formula-fields with a "CHR(13)" and tried it out........... damn, still the same ugly result =<



Edited by crystallize - 26 Jan 2011 at 10:10pm

Arial size 9.
I also tried many other (Times new roman, courier new ......)



Edited by crystallize - 27 Jan 2011 at 4:20am