Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: otsizh on 25 Oct 2005 09:41:26 AM

Title: [Solved]sort /not sort with conditional variables
Post by: otsizh on 25 Oct 2005 09:41:26 AM
Hello,
Is it possible to sort a column or not with conditional variables? I tryed and it is looks like when I do sort under condition it is stays there even I double click green bar (conditional explorer)

thanks, olha
Title: Re: sort /not sort with conditional variables
Post by: sir_jeroen on 25 Oct 2005 10:09:35 AM
Of course... Just make a hidden hidden column on which you sort. Make the query item in item dependent on the conditional formatting.... But... this sounds like a nice small tutorial... so maybe... If my GF allows me tonight to build one ... :D
Title: Re: sort /not sort with conditional variables
Post by: otsizh on 25 Oct 2005 10:27:32 AM
well all columns should be shouwn inthe report:
column A      column B    column C
1                      z               x
5                      f                x
3                      d                y

then I have a conditional variable which is based on the prompt selection (sort by A,B,C) if A was picked everything should be sorted by column A,
column A      column B    column C
1                      z               x
3                      d               y
5                      f                x
if B - then by B,...
column A      column B    column C
3                      d               y
5                      f                x
1                      z                x

thanks for trying to make a tutorial -I like them very much!
but some recomendations would be fine also,.... hello to your GF ;)!
Title: Re: sort /not sort with conditional variables
Post by: sir_jeroen on 25 Oct 2005 10:36:34 AM
Ok.. you won yourself a tutorial... Keep checking this site.... :D
Title: Re: sort /not sort with conditional variables
Post by: otsizh on 25 Oct 2005 10:45:12 AM
YESSSS!!!!!!!!!!!!!!!!!!!!!!! ;D
Title: Re: sort /not sort with conditional variables
Post by: sir_jeroen on 25 Oct 2005 10:58:29 AM
Just wait 'till the bill arrives :P
Title: Re: sort /not sort with conditional variables
Post by: sir_jeroen on 25 Oct 2005 04:09:04 PM
Get out your wallet... The bill is on the way.... :D

A new tutorial:
How to create a list item with custom sorting


Btw... Will you change this topic to [Solved] if your problem has been answered?
Title: Re: [Solved]sort /not sort with conditional variables
Post by: Blue on 11 Dec 2005 11:55:29 PM
Thanks RNA, nice tute.

I created a similar solution however when I use either yours or mine I get the following error:

Handler trace back:
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
[warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler
[do_warp] com.cognos.pogo.handlers.logic.ChainHandler
[warpmta] com.cognos.pogo.reportservice.ReportServerHandler

I could find any info ono this in the Cognos Knowledgebase.

I noticed you created your conditional sort item directly in the report page.  I created mine in the tabular model then imported into the query but not on the report page as I didn't want the user to see it.  I need it in the report query so as to set the sort property. 

Any ideas?
Title: Re: [Solved]sort /not sort with conditional variables
Post by: sir_jeroen on 12 Dec 2005 07:32:05 AM
Remove the sort column but don't forget to deselect the option "remove unreferenced query-items" under Report options... Your user won't see it but it will be used..
Text only | Text with Images