Hello,
I am fairly new at Cognos Report Studio.
I wanted to know how you can sort a particular column on its values, like if I have a column named Campus, and the values are Texas, New Jersey, Alabama, Florida, Main, South Carolina and I want to sort it alphabetically but Main the as the last item as below:
Alabama
Florida
New Jersey
South Carolina
Texas
Main
like so, How is it possible in report studio?
Thanks in advance,
NBC
You define a premier sorting item:
CASE WHEN [STATE] <> 'Main' THEN 1 ELSE 2 END
Now associate this new item with the list properties and add a detail sorting to the list. First sort on the new item, then on [STATE], et voila..