select most recent 4 occurances to report 1

[gards1964]

I am using CR 11.0.
I have a report that takes multiple rosters and calculates a pass rate for each academic classes and the total. The report is currently based on a time selection (last year) of (between 2 dates). The powers that be now want to start ignoring date ranges and select the last 4 rosters per academy.

Group 1 Acad_Name
Group 2 Roster_id
Group 3 Student_name
details

Group2 includes the field Course_date so if I could get the most recent 4 rosters based on that field I'm probably done.

TIA
RG

 

[lbass]

Try inserting a maximum on {table.coursedate} at the RosterID Group level and then go to report->group sort->topN: 4->maximum of {table.coursedate}-> descending.

-LB