dynamic sorting

[vsud]

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.