Cognos 11 Report Sorting

[kennedto]

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?

[dougp]

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?