Automatically "left-shift" a field
Posted: Fri Dec 07, 2007 7:49 am
I have three fields, one with a fixed text, one with a sum of a database field (eg. "Sum(Amount)") the other one with a fixed text. I need to obtain something like:
"Total amount: 123,45 including VAT."
The value "123,45" represents the second field.
I have designed the report this way:

but the result is:

while i wanted this:

In few words, i need that the third field ("including VAT") shifts to left according to dynamic dimension of the second field.
I know that i can do a single text field, but i need to format the value field, so it must be separated from the others.
Is there a way to solve this?
Thanks.
"Total amount: 123,45 including VAT."
The value "123,45" represents the second field.
I have designed the report this way:

but the result is:

while i wanted this:

In few words, i need that the third field ("including VAT") shifts to left according to dynamic dimension of the second field.
I know that i can do a single text field, but i need to format the value field, so it must be separated from the others.
Is there a way to solve this?
Thanks.