ZIP-CODE Sorting

[robin2008]

I am doing sorting my report using prompt page......and It works for COMAPNY_NAME (varchar).............and this the way I did

propmt page---drag value prompt---select static choice---add the dispaly(ZIP CODE)--OK--got to Query Explorer---drag new data item----write expression
case ?Parameter1?
when 'code' then [ZIP-CODE]
end
ok(no error).----then go to report pages---click page set--go to group and sorting...click on sort list and drag this new data item below sort list...then RUN

But issue is ..now I am trying to do for ZIP-CODE(varchar) but not working.......
please any idea ...any help.........

thnak you
robin

[robin2008]

Is there any COGNOS Guru who cha give some help on this matter, please............

robin

[pooja]

I that should work

[robin2008]

its not working

plz help any friends out there

[blom0344]

Can you be more precise in what does not work? Does the sorting on the ZIP code not work like you expected? How do you expect the sorting to be? ETC