The Uncompleted Rank Requirements By Requirement report lists each rank requirement and shows the scouts who have not yet earned that requirement.

To produce this report, go to Advancement → Requirement Reports → Uncompleted Rank Requirements By Requirement.