I have a situation where I want the report to group at a state level. The problem is each record could involve multiple states. So, the record could appear on the report multiple times, but only once for each state. For example, a record 123abc with KS/CA/KS/KS/KS/ID should appear in the group for KS, CA, and ID. Also, any states without a record should not appear (the least of my concerns right now).
Given 123abc - KS/CA/KS/KS/KS/ID and 789xyz - CA/NY/CA/CA/CA/NY, I envision the report looking like:
CA
123abc
789xyz
ID
123abc
KS
123abc
NY
789xyz
Perhaps this starts at the query, but I'm not quite sure where to go with this or if it's even possible. If additional information is needed, please let me know.
Thanks,
Laura