COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: beerguy82 on 21 Nov 2008 08:19:29 AM

Title: Static choices/sorting/conditional block issue
Post by: beerguy82 on 21 Nov 2008 08:19:29 AM
I'm in the process of consolidating two similar reports written by my predecessor into one report.  It is set up to be able to be sorted by using some static choices in a value prompt to drive a parameter defined as: #sb(prompt('Order By','token','Rank'))#
This works fine for the original list, but I inserted a conditional block and put another version of the list in the report, along with another conditional rendering of the value prompt to show one or the other depending on a parameter chosen on a prompt page.  When I choose the "new" parameter, everything shows up correctly, but the static choice value prompt does not sort the new list.  I feel like I am missing something very simple needed to link these two conditionally rendered items together.  Any help would be greatly appreciated. 

Tim
Title: Re: Static choices/sorting/conditional block issue
Post by: Suraj on 21 Nov 2008 10:47:29 AM
could you post sample report against gosales?
it'll be easier to play with that.