>Is there any way that I can specify dynamic picture clause for numeric field but using the report writer, for eg. I want to run the same report FRX with a picture clause of 999999.999 in one machine and 9999999999 in another.
>
>I tried storing the picture in a variable and gave it in the format didnt work nor was the macro substitution of the same

Do your conditional formatting in code before you issue the REPORT statement. Create a string memvar, formatted as desired, and have the report print that instead of the actual numeric field.