# How do I create personalized reports in Report Builder? For example, I want to run a report to see who has not passed the 1st class swim test requirement

**URL:** <https://discussions.scouting.org/t/how-do-i-create-personalized-reports-in-report-builder-for-example-i-want-to-run-a-report-to-see-who-has-not-passed-the-1st-class-swim-test-requirement/172441>\
**Category:** Using Scoutbook & Scoutbook Plus\
**Created:** [June 18, 2020, 12:40am UTC](https://discussions.scouting.org/t/how-do-i-create-personalized-reports-in-report-builder-for-example-i-want-to-run-a-report-to-see-who-has-not-passed-the-1st-class-swim-test-requirement/172441 "2020-06-18T00:40:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DavitaBaloue](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@DavitaBaloue](https://discussions.scouting.org/u/DavitaBaloue)\
**Post date:** [June 18, 2020, 12:40am UTC](https://discussions.scouting.org/t/how-do-i-create-personalized-reports-in-report-builder-for-example-i-want-to-run-a-report-to-see-who-has-not-passed-the-1st-class-swim-test-requirement/172441/1 "2020-06-18T00:40:38Z")

</div>

How do I create personalized reports in Report Builder? For example, I want to run a report to see who has not passed the 1st class swim test requirement. I also want to run “group” reports, not just individual reports.

---

<div class="post-metadata">

**Author:** ![CharleyHamilton](https://sea2.discourse-cdn.com/scouting/user_avatar/discussions.scouting.org/charleyhamilton/32/3113_2.png) [@CharleyHamilton](https://discussions.scouting.org/u/CharleyHamilton)\
**Post date:** [June 18, 2020, 1:14am UTC](https://discussions.scouting.org/t/how-do-i-create-personalized-reports-in-report-builder-for-example-i-want-to-run-a-report-to-see-who-has-not-passed-the-1st-class-swim-test-requirement/172441/2 "2020-06-18T01:14:51Z")

</div>

Adult leaders with View Profile or higher permissions to all scouts (I think) can pull the swim test dates for scouts using Roster Builder Manager under Reports at the bottom of your troop page.

If you specifically want the rank requirement, there isn’t a way to only report the scouts who do or don’t have that requirement. You can, however, use Report Builder to create a report on only the First Class rank requirements. However, you will get different tables of data for different scouts, depending on which version of the rank requirements they completed First Class under. It’s not particularly pretty, IMHO, but you can generate the data.

If you care about the formatting, a unit admin can dump the advancement database to CSV format file, and generate reports from there in Excel or a similar spreadsheet program.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/scouting/original/1X/66e9612584db5dbf76de17f00ad877998c0ba3d6.png) [@system](https://discussions.scouting.org/u/system)\
**Post date:** [June 25, 2020, 1:14am UTC](https://discussions.scouting.org/t/how-do-i-create-personalized-reports-in-report-builder-for-example-i-want-to-run-a-report-to-see-who-has-not-passed-the-1st-class-swim-test-requirement/172441/3 "2020-06-25T01:14:57Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.