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

    FM 13 Adv Sub Summary not Summarizing?

    synergy46

      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:

       

      relationships.png

       

      Here is the layout:

      category2layout.png

       

      Here is the output after the script runs it:

      ReportOutput.png

      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:

      ScriptCategories.png

       

       

      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?

       

      Thanks

       

      Ron