Format Value.

[esanray]

my report display the value like '500' but i want to display my value like '0500' .any body please tell me how to format the value?

[pricter]

Did you tried to change the number to a string and concatenate it with the zero?

[blom0344]

If the value of 500 is based on an aggregation then casting it to a string would negate the aggregation = no use. If it is a non-aggregate and not used in a crosstab then casting and concatenating the zero may work..

[cognos_guru]

You should be able to change the display using the format settings and padding characters...