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
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
Steve, have you tried JGirl's solution? Did it work? Please keep us posted.