COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: everlearner on 17 Jan 2013 05:56:20 AM

Title: how to display the latest status as per the date?
Post by: everlearner on 17 Jan 2013 05:56:20 AM
Hi gurus,

in my report 2 query items status and date are there.
i have to display only status. that too latest status and i should not display date in the report.

example

status     date
abc        01/01/2013
bcd        06/01/2013
cde        012/01/2013


my output should be

status

cde


how to get this?

thanks in adv.