I have a project with several locations, each will be built separately as that is how I chose the locations. So, to support this, I need a BOM for each of the locations to be built separately.
I have a "BOM by location" in which I have all of the BOM's I actually want, but they are back to back and overlapping, I need them on separate pages with separate titles. I just need to find out how to filter out the locations I do not want, and re-generate the report for each location that I do want with the others filtered out.
I hear in 2016 this is a snap, but I'm still on 2015, so I believe SQL editing may be in order, but I'm not that proficient so I need some hand-holding.
Any help is appreciated.