PMFJI,

One caveat to this method is that you can no longer sum this field directly since the type in now character. You can still sum using a report variable

Just my $0.02

Rex

>>>Hello everyone,
>>>
>>>I need to print the same report with two diferent inputmask's in some of the fields like :
>>>
>>>I want to run the report sometimes with a format like :
>>>. "###,###.#"
>>>
>>>and sometimes with :
>>>
>>>. "###,###.##"
>>>
>>>I've tried using a variable and a macro in the format option of the field in the report, but nothing worked.
>>>
>>>
>>>Thanks in advance,
>>>
>>>
>>>Ricardo Parreira
>>
>>You can use TRANSFORM as the report value and do the format at report run time:
>>
>>TRANSFORM(value,IIF(condition=1,'###,###.#','###,###.##'))
>>
>>Just make sure to leave enough room for the larger field.
>
>Good idea
>
>Thank you very much.