I am using Cognos 11.09. In the report editor, I have a query object with
month(num),monthname(Jan-Dec), Confirmed(integer) Attended(integer)
fields. The query object is set to sort (ASC) on the month. When I review the tabular data, the sorting works fine.
If I add this query to a List Report and include the
monthname, Confirmed, Attended
fields and group on monthname the output is no longer sorted. The only reason I have the month field is to sort the data by month properly. How can I get the List report output sorted with out including the month field?
By sorting the list by the month field, but not adding the month field to the list. Have you tried the Grouping & sorting property of the List object?