Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: esanray on 14 Nov 2011 09:48:50 AM

Title: Format Value.
Post by: esanray on 14 Nov 2011 09:48:50 AM
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?
Title: Re: Format Value.
Post by: pricter on 15 Nov 2011 02:30:22 AM
Did you tried to change the number to a string and concatenate it with the zero?
Title: Re: Format Value.
Post by: blom0344 on 15 Nov 2011 11:26:10 AM
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..
Title: Re: Format Value.
Post by: cognos_guru on 15 Nov 2011 01:44:38 PM
You should be able to change the display using the format settings and padding characters...
Text only | Text with Images