[Solved]sort /not sort with conditional variables

[otsizh]

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

[sir_jeroen]

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

[otsizh]

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 ;)!

[sir_jeroen]

Ok.. you won yourself a tutorial... Keep checking this site.... :D

[otsizh]

YESSSS!!!!!!!!!!!!!!!!!!!!!!! ;D

[sir_jeroen]

Just wait 'till the bill arrives :P

[sir_jeroen]

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?

[Blue]

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?

[sir_jeroen]

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..