OK. I've done lots of these reports and they work. For some reason (undoubtedly my fault) I can't see what is causing this one to not work.
It is pretty simple.
All I want is a sub summary by Category::Category and Category::Skill that shows People::c_FullName as well
Here are the relationships:
Here is the layout:
Here is the output after the script runs it:
Notice how the subsummary field is only picking up the first Category and even
after the sort, Category is STILL not sorted?!!! huh?
Here is the script:
I've been wrestling with this for several hours. I suspect that my sort for some reason is not working. But, I have deleted the sort and redone it. I have manually sorted (Task Bar) to no affect. Can you see what I am doing wrong?
I had neglected to reset the Category and Skill fields from Number to Text after they were created. OOPS.