Format

sabzam

<Sign>$<Integer Thousand><Decimals>

Hi Everybody,
I have the above line in the format of a field in a report. I would like to replace the $ by a variable. Is it possible?

Regards,


Sabzam

danlindstrom

I asume you are using:
FORMAT(var,0,'<Sign>$<Integer Thousand><Decimals>');

try

FORMAT(var,0,'<Sign>'+signvariable+'<Integer Thousand><Decimals>');
should work

sabzam

Hi, It's not working ufortunately.

Fordewind

sabzam wrote:

Hi, It's not working ufortunately.

Use CONVERTSTR after FORMAT (if better way will not be found)

sabzam

Hi Everybody,

For some reason or another the format above is not working whenever a variable is extracted for a record. If for example we have a decimal field let's say amount and a decimal variable, the format works in the variable but completely ignores it in the field.

Does anyone have any idea of the source of this issue?

danlindstrom

I' have recently seen this in reports when I tried to limit the use of DecimalPlaces.
If you are using "table"."field" as SourceExpr the fields property overrides the setting of DecimalPlaces of the TextBox. But if I use +"table"."field" as SourceExpr I'm able to control.

It might be the same for the Format setting in the TextBox.

(all in the properties of the textbox)

sabzam

Hi

Great, it has worked perfectly. The only remaining issue which i have is that I would like to place a variable instead of the euro symbol in the format. Below you will find the current format.

<Sign>€<Integer Thousand><Decimals>

How should it be written to insert a variable instead of the euro sign?