Could anyone please tell me how to get webfocus to only show the latest record for a particular table?
I want the report to only show the following (highest Date1):
I tried displaying LST.Date1 but it did not work.
In SQL I could do something like this:
ROW_NUMBER() OVER ( PARTITION BY Account, Suffix, ID, Type ORDER BY Account DESC ) rn
GlenThis message has been edited. Last edited by: FP Mod Chuck,
BY HIGHEST 1 Date1 will limit the records to the one that has the record you're looking for.
WebFOCUS 8206, Unix, Windows
BabakNYC you are a genius. Thank you so much!
|Powered by Social Strata|