Hi,
Not sure if there are any CR developers out there but here goes.
I'm trying to get a report to display the last record in a group.
The report is grouped by Incident Number, then within that there are numerous records - each with an incrementing sequence number.
I only want the last sequence number in the assoc. group? I've tried using maximum() but this doesn't work.
Preferably I'd like to include this at runtime as opposed to surpressing the unwanted values.
Cheers!
Not sure if there are any CR developers out there but here goes.
I'm trying to get a report to display the last record in a group.
The report is grouped by Incident Number, then within that there are numerous records - each with an incrementing sequence number.
I only want the last sequence number in the assoc. group? I've tried using maximum() but this doesn't work.
Preferably I'd like to include this at runtime as opposed to surpressing the unwanted values.
Cheers!