COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: esanray on 06 May 2011 01:00:28 AM

Title: Last Record
Post by: esanray on 06 May 2011 01:00:28 AM
How to filter the last  updated record only in report studio.
Title: Re: Last Record
Post by: blom0344 on 09 May 2011 04:29:09 AM
Sort data descending on the date; add a rank item and use this in a summary filter..
Title: Re: Last Record
Post by: RobsWalker68 on 09 May 2011 08:56:03 AM
Create a filter based on the column that can be used to identify the latest record: [Identifier Column] = maximum([Identifier Column])

Rgds

Rob