I am facing an issue in cognos 8.4 charts. I have a report which was recently upgraded from 8.2 to 8.4
in 8.4, the chart displayed in the report automatically gets sorted in alphabetical order on the material code value that is been displayed in x axis.
None of the data item, material code or the measure has been given an option to get sorted on the material code.
But in 8.2 the charts were not sorted.
Now my users want the output to look exactly similar to 8.2 output.
Can some one help me in solving this Issue.
Well, can you check in the data base table and see if [material code] is been defined as a Clustered Index. If yes, can you change it to Non-Clustered Index and see if it helps?
material code property to Non-Clustered Index insted of Clustered Index.u can resolve it.
Thanks guys for the reply :)