Pack Slip Help

Long story short:

I was asked to create an custom SSR Pack Slip based off of their Crystal report. I have this part 100% done. Next they asked me to add in an custom field that tells them the location of the part. No problem-Done! Now they want the parts to be sorted based on their location.

This a column/row but a text box in a rectangle in the Row. The red line is the row, the highlighted is what they want me to sort by. Note: The text you see is NOT what tat text box is. I have changed it on the backend, but it hasn’t show up there for me.

Figured out the sorting/grouping, but the Child parts do not have anything in this field, so they are getting lumped all by themselves. I’m also having issues getting it setup for the child to sue the Parents number. Ideas on how to do that?