COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sg24 on 12 Jan 2011 07:40:32 AM

Title: Sorting
Post by: sg24 on 12 Jan 2011 07:40:32 AM
Hi ,
I have a value prompt in which the values are,
E-Exceeds exp
N-Needs Improvement
O-Outstanding
P-Proficeint

these are coming through some condition like in the data item like,

if (ABC='O') then ('Outstanding')
else if (ABC='P') then ('Proficeint') etc.

Now my requirement is i need this in a way as shown below.

O-outstand
E-Exceeds Exp
P-Proficeint
N-Needs Improvemnet

Please let me know.

Thanks in Advance.
Title: Re: Sorting
Post by: dtopicMedV on 12 Jan 2011 07:47:24 AM
create new calculation like :

if (ABC='O') then (3)
else if (ABC='P') then (4) ...
and set value prompt sorting property to that new calculation
Title: Re: Sorting
Post by: sg24 on 12 Jan 2011 07:52:21 AM
Thank you very much for the response. It worked fine.

Thanks,
Sg