How Do I Change Sort Order on Selected Prompt?

[sleepy]

Does anyone know how to control the sort order of a ââ,¬Ëœselected promptââ,¬â,,¢. (... which I created using the ââ,¬Å"Displaying Selected Prompt in Cognos ReportNet Report Studioââ,¬Â knowledgebase article). The selected prompt is set on a date column/field.

When running the report the user gets a prompt which appears in the format ââ,¬Â¦

FEB-04
FEB-05
FEB-06
MAR-04
MAR-05
MAR-06
APR-04  ââ,¬Â¦ etc

I wish it to appear as ââ,¬Â¦

FEB-04
MAR-04
APR-04
MAY-04 ââ,¬Â¦ etc

How do I achieve this? I have tried putting sort order on the data item but this has made no difference.

Cheers,
steve ;D

[JGirl]

create another data item in the query that populates the prompt to sort on.

Since your prompt contains month, you need to have a column that is something like YYYYMM (eg. 200401) for each month.  Then sort on this column and no others and that should be it.

J

[bdybldr]

Steve, have you tried JGirl's solution?  Did it work?  Please keep us posted.