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.
I have a request for a canned report - display the status for requirements indicated for Life req 3 (the EDGE requirement) for Scouts who have not yet completed up through 1st Class.
I know can generate a CSV file, delete out the extraneous columns etc. But to save the time of dealing with it, why not have a canned report? When your Star Scout working towards Life is looking to find out who might need to be EDGEd on any of those requirements, just run a simple report showing the status of only those Scouts not yet reaching 1st Class and displaying ONLY those qualifying requirements to easily identify who to approach.
Win-win - the Star Scout knows who to approach quickly, the other Scouts needing those requirements have an opportunity to be EDGEd and then demonstrate to a SM or qualified Scout for approval with minimal hassle or delay by somebody else.
I have to admit I’m not sure what’s so difficult about expecting the SPL, ASPL, PL, Troop Guide or even the scouts who are looking to complete the EDGE method requirement to read a summary report of the Tenderfoot, Second Class and First Class requirements and figure out which ones aren’t marked Approved yet for the relevant requirements. We used to do this with the old hardcopy wall charts (or directly from their handbooks) in the pre-Scoutbook days. Shouldn’t there be some level of initiative from the relevant scouts to pursue that requirement without needing a neon sign telling them who needs teaching?
Is the kind of search that this feature request is making something that is challenging to implement, relative to other priorities? I can understand if creating on-the-fly (or canned one for a specific report) these more involved SQL queries is not a priority (but then it is a feature request, not a bug report). I can write a macro-enabled spreadsheet to parse the data the way I want, but then why not see if the tool can provide the request directly?
Implied/assumed philosophical gate-keeping/enabling differences aside, the Life EDGE requirement 6 indicates nothing about how a Scout identifies the Scout(s) to be EDGEd.
As Donovan said, you can build this report in Report Builder.
Scouting America IT is not interested in creating a plethora of canned reports when they can be easily created via Report Builder. Once you have created the report you want, you can save it and share it with other members of your troop.
