By using this website, you agree to our Terms of Use (click here)
I have created a time-phased inventory report. It starts by pulling all my warehouses together, then groups by itemID, then sends that ID over to a sub-report (which applies demand/supply etc). This all works just fine. The report is sorted by ItemID due to the grouping in the master report. What I'd like to do is to have it sort by the item's STATUS then by ItemID. Ascending order is fine as it would put my "active" items first. How in the world do I overrride this sorting by the group to be secondary to a sort by status? I've tried all sorts of odd things in the schema builder's group tab, but it ALWAYS sorts by that grouping... Anyone come across this and found a solution?
Also, hello everyone. Having browsed around here a bit, I think I'll be coming back all too frequently. Below is a snippet of my report that refuses to sort for me 😀
Hey Michael,
Welcome and thanks for posting here.
You could try adding a field to the grouping like this:
1. Open the Groups area:
2. Modify your item's group collection:
3. Add a new group member for ItemStatus and move it above the InventoryCD group which will cause it to sort first by ItemStatus.
Keep in mind that when you add a group member like this, it could change the "grain" of the group. But, in this case, an item can only have one status so it won't change the "grain".
Here is the sample report that I created if you want to take a look at it:
That is perfect. I split the groups into two, just for simplicity for myself, but your solution is perfect. It now sorts according to plan!
Awesome. Thanks for the feedback.