Not sure why you have all those calc fields.
If you have this relationship:
Student --< ActivityParticipation >-- Activity >-- Booster
Then this …
I have a nice report for the Athletic Boosters that lists all the students (and their families) and lists the sports they play via the zi_actSportsList field.
… could simply be done by basing your report on the ActivityParticipation layout, after finding all records that are related to an activity with a foreign BoosterID. (Activity::BoosterGroupID = "*")
If you want to do this:
The problem is when I want to use the same layout for the Music Boosters
You can use the same report layout and simply search for all records that denote Activities that belong to the Music booster group. (Booster::BoosterGroupName = "Music")
It's interesting how a break can bring clarity. I figured it out... I just needed to put a global field in my Activity Participation calculation field: If (Exact(Activity::zk_CommitteeID.t;zg_CommitteeID.g);Activity::Activity.t;""). For some reason a global variable isn't working. Anyways, this helps eliminate the need for separate calculation fields per booster group as well. Thanks!
Well, that break may have brought you clarity on how to solve an issue that you shouldn't have in the first place.
But did you actually read my response?
Yes, erolst, I read your response and considered it. I may have oversimplified my question and so I guess it wasn't a good question. Thank you again for taking the time to help!