Print Page - Order By DESC MACRO Prompt Not respected

Title: Order By DESC MACRO Prompt Not respected
Post by: Blacksails on 20 Oct 2016 07:24:19 AM

Hi guys, ive the same situation to resolve in this note. http://www-01.ibm.com/support/docview.wss?uid=swg1PM16343. i would like to know if it is possible to sort in a descending order a macro prompt values list that uses a date data item. users will be using this ordered list in workspace advanced to filter in advance query subjects that have inside the filter prompt macro. Thx

Title: Re: Order By DESC MACRO Prompt Not respected
Post by: Blacksails on 20 Oct 2016 07:26:59 AM

hi guys i ve a similar situation to this case . http://www-01.ibm.com/support/docview.wss?uid=swg1PM16343. It is possible to satisfy this user requirement?thx

Title: Re: Order By DESC MACRO Prompt Not respected
Post by: Blacksails on 20 Oct 2016 07:31:29 AM

I ve tried with dmr and also using pass through sql but cognos ,ibm cognos sql Always show a group By that distrupt my DESC ordering...

Title: Re: Order By DESC MACRO Prompt Not respected
Post by: Blacksails on 20 Oct 2016 07:37:28 AM

Also using DMR Query subject and defining ordering levels but nothing change.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Blacksails on 20 Oct 2016 07:24:19 AM