Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Studio - Select Latest Date Value

Status
Not open for further replies.

handpass

Programmer
Oct 13, 2006
10
US
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.
 
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 [pc2]
Want good answers? Read FAQ401-2487 first!
 
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
 
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])



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top