dynamic sorting

[vsudaya]

Hi all,

I have requirement where i need to sort on different fields(eg:ProdcutlLIne,Product Name, Product value ascending,descedning) dynamically in report viewer. The report should be grouped on Product Line and Product Name. I need group wise values, names sorting(ascending and descending) and inside group also values to be sorted.

my data displayes like this

Regards
Udaya
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 

[angela]

We're looking for this functionality too.Ã,  So far the only solution I've seen is to use a value prompt which activates a sort key column (which is hidden) which contains a big IF or CASE statement.

Instructions to do so are here:

http://wiki.ittoolbox.com/index.php/FAQ%3AHow%5Fcan%5FI%5Fdynamically%5Fsort%5Fon%5Fdifferent%5Fcolumns%3F

[bdybldr]

You could do it that way or you could create variables and define conditional styles based on those variables.  You could also use conditional block.  Keep us posted.

[angela]

Support gave us some javascript solutions.  The version 7 one we cannot test.  There are 2 version 8 ones - only one works if you have a summary footer.  Those version 8 ones are listed on the bottom right side of http://businessintelligence.ittoolbox.com/groups/technical-functional/Cognos-ReportNet-L under the "Code" section.

Good luck.

[sharu_bs]

Did u get any solution for this problem????? ???

[angela]

At the bottom of this page: http://businessintelligence.ittoolbox.com/groups/technical-functional/Cognos-ReportNet-L is a section for Code.  There are some solutions there including one which doesn't need any Javascript at all.