1 Reply Latest reply on Jan 26, 2014 8:39 PM by synergy46

    FM 13 Adv Sub Summary not Summarizing?


      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?