Reverse Engineer Report - Help Please

[Former Member]

I'm trying to figure out how this report looks for the past blood drives (up to 3).  But I can't find where in the report it limits the past drives to 3.

The report is attached and you can see the sub-report is named past3Blooddrives.rpt.

I'd like to find out how this report is managing to do so because it would be handy for future reports.

Any idea on how this is being accomplished?

Should be able to download the report here:

Past3Drives.rpt - Google Drive

Thanks,

[JWiseman · Accepted solution]

hi Trey,

if you go to the past3blooddrives subreport and then click on the Group Sort Expert, there is a Top 3 being based on a summary on the drive date.

this method is fine to use when you're not bringing back tons of data. essentially it suppresses the remaining groups after the Top N (in this case 3) groups are found.

if you've got a report that runs way too long as there's a lot of data coming back, then consider doing the the Top N by basing your report off of a Command object that utilizes a SELECT TOP N instead.

cheers,

jamie

[Former Member · Accepted solution]

Thank you, missed that.