In this report, we will create a custom report that will group by material, then by banding code, and then display results. It's for Adj. Shelves only, but the principles work for all parts.
So...near the end of the video (which you should watch before worrying about this), I will show you that the Cabinet (Qty) SQL is incorrrect. To make the correction, you have to do the following:
Alter the Original SQL in the PartList table, not the Link, found here:
https://www.dropbox.com/s/vf21kcwjtkpgjwl/CustomReport_EdgebandHeader_PartListSQLCorrection.txt?dl=0
Now, alter the Caibnet(Qty) SQL to the one located here:
https://www.dropbox.com/s/fzypmuqcg4k8ppn/CustomReport_EdgebandHeader_PartListCabinetSQLCorrection.txt?dl=0