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 setup a custom report that gives me the list of all scouts in the troop with their respective Merit Badge completion dates. I have selected the following options in the Report Builder
When I run the report, few of the scouts from the troop are missing on the report even though they are active and are earning merit badges. How would I go about getting this fixed?
@DonovanMcNeil@VinayKashyap I would say that yes, these look to be mutually exclusive with the logic and could be causing the problem by selecting both. I would suggest trying the report with each one separately and see if that produces the correct expected results. If so, the solution would be two separate reports each with the different purpose.
I will have to ask the developers if a union of these is possible to bring the correct report.