Chances are that if you only have one table (I didn't look) you're always going to have issues of one sort or another. Having 5 subreports is not the way to go (not sure how you arrived at 5 when you show 7 case managers in the pdf). Perhaps a crosstab query would work for you, but you'd have to define the fields in the query property sheet, otherwise it would raise an error when you have no records for any one manager.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.