Report Studio - Select Latest Date Value

[handpass]

I am creating a report that is currently returning a number of records. One of the columns in this report is a date entry. Of the records that are being returned I only want to use the one that has the latest date value. Is there any filter I can use to apply to this column so that only the record with the latest date will appear.

Thanks in advance.

 

[griffindm]

Filter on the maximum date value, but realize that this must be a summary filter, and is subject to grouping within the report.

Dave G.


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[almeids]

You could also add a tabular submodel (assuming ReportNet, not C8) which selects the maximum date only and use that data item in a filter in your tabular model.

Steve

 

[handpass]

Cheers Dave, that worked a treat.
Grouped on INPUT DATE. ID CODE is the unique value in each record.

[INPUT DATE] = maximum([INPUT DATE] for [ID CODE])