COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: billylodz on 30 Oct 2007 07:01:19 AM

Title: Sorting in crostab
Post by: billylodz on 30 Oct 2007 07:01:19 AM
Hi.

It's my beginning, so some simple things are hard for me in Cognos.

I have specyfic sorting for Products in cube, it works fine for list,
but I need to use te same sorting in crosstab, is it possible ??.

any other solutions ?
Title: Re: Sorting in crostab
Post by: rockytopmark on 30 Oct 2007 07:05:50 AM
You will need to use the Order() function in your Row Edge expression.  There is great help and explanation in Report Studio help and User Guide, for all the MDX functions.


My advice is to learn about sets, members and tuples before you get into using these functions.
Title: Re: Sorting in crostab
Post by: Venu_Gollapudi on 06 Nov 2007 11:00:53 PM
The other way is if you are familier with Java Script you can do the sorting by inserting HTML objects in your report.