How to change the Display Pattern for Decimal Fields dynamically

[Former Member]

hi all,

Can any one help me how to change the display pattern for decimal fields dynamically???

Currently I am using z,zzz,zzz,zz9.999 Display pattern for Quantity Field. If the value is blank it is displaying as 0.000 on the Screen. But I don't want this to be printed.

Please help me how to solve this ASAP.

Thanks,

Prabhu

[Former Member]

Hi,

Alternatively you can handle it in the context.

In the context area, click on the quantity. In the bottom, click on the conditions tab, and put a condition

<quan field> NE initial.

So the field will not be printed if there is no value.

Regards,

Vidya Chowdhary A.

[Former Member]

Hi Prabhu,

Even I had tried to do that. But could not resolve.

I had then got another solution.

- Make the cell invisible/hidden.

- Set the font color of that particular cell as white. You can write a Form Calc script to change the font color, conditionally.

Thanks,

Shweta

[Former Member]

Thanks Shwetha.

I am trying to set the field width to 0.

If that doesn't work I will try your approach

[Former Member]

Hi Prabhu,

You can even try to hide that field when its value is '0.000' using Java Scripting..

Regards

Sitharamaraju