Welcome! This forum has a treasure trove of great info – Scouters helping Scouters! Just a heads up, though - all content, information, and opinions shared on this forum are those of the author, not the BSA.
@RichardScalzo have you looked at Report Designer? It’s accessible from the dashboard or unit page. This is customizable to be able to build reports (and save a configuration to run again later). Much of this information is available there.
I created a number of reports similar to what you described. Here is a screenshot of the list. As Matt noted, I can share them with all the other leaders in the troop so they don’t have to recreate the reports.
My only complaint is that the report builder will not automatically filter the troop roster by rank - so for instance, I have to manually select those scouts who are not yet First Class for that report. Once a scout earns first class, I have to remember to remove him from that report and add him to the Trail to Eagle report. For a troop of 30 scouts that is not too bad. It would be harder in a very large troop.