Yes, a client can have more than one outcome.
Would something like this work?:
Client_ID, Visit_ID, OC_1, OC_2, OC_3, OC_4
01, v01, 123, null, 789, null
01, v02, 123, null, null, 221
02, v03, null, null, 789, 221
03, v04, 123, 456, null, 221
*each outcome(OC) has a code associated to it.
Results would show as:
Type Clients % Visits %
Outcome_1 2 66% 3 75%
Outcome_2 1 33% 1 25%
...
This is basically what I'm trying to accomplish, let me know if you need more information.
The actual report is even a bit more complex in that I need to set up a heirarchy based on other columns in this table - where say
Outcome_1 ....
Outcome_2....
Outcome_3....
Outcome_4....
But I'm not touching that yet.
Thanks!,
-Matt