COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jeeva on 01 Aug 2016 04:12:31 AM

Title: dynamic column sorting on date column
Post by: jeeva on 01 Aug 2016 04:12:31 AM
Hi,

i am applying the dynamic column sorting in a list report using drill through definition. it is working fine with the character and integer columns. But not sorting on date column. how can we do this?

we are using the progress open edge as a database.

Thanks,
Thanay
Title: Re: dynamic column sorting on date column
Post by: cognostechie on 01 Aug 2016 12:41:23 PM
You mean the data resides in Progress Openedge ? Doesn't that require to connect via ODBC? I used to be a  Progress 4GL programmer a decade ago and remember that lot of things in Cognos didn't work they way it was supposed to and eventually found out that the way Progress interprets SQL was the problem more than anything else. That, of course, was long time back so not sure how it is now but if it is the same then you have the answer. Maybe someone else can chip in here.