I just made a baq + SSRS report that is supposed to show the number of parts we have in what bins, and it is supposed to sort by bin itself. The BAQ itself is sorting correctly, but the report is not. The SSRS report is sorting by part number going from A-Z, even though the BAQ has sort by bin, and BAQ Report Designer has PartBin_BinNum in the sort fields. I even tried manually editing the table properties on the report to sort by binnum, but that did not work either. What am I missing here?
BAQ:
Multisite or multiwarehouse? Add Company, Plant and WarehouseCode ahead of BinNum in sort and display. Also make sure Company field is added to BAQ join.
Right… so, your report is currently set up to group by PartNum first (the upper most parent). Then, a bunch of others, and finally BinNum.
If you want to sort by BinNum for the whole result set, it should probably be the upper-most parent group. You want to group things by BinNum first, then by PartNum, then by… whatever.
That way you’ll get all parts in Bin 01, then all parts in Bin 02, then Bin 03, etc.
I would suggest leaving the existing tablix alone for now (just in case you have to retreat)… But add a new tablix underneath (lower on the page). Set it up so BinNum is the top group. When you run the report, it should run both and you can see if the sort order is closer to what you want. Once you get what you need, you can delete the original tablix.
OR… if “sorting by bin” is truly an option. I would keep both tablix (tablixes, tablixies, tabli??) and you can set visible conditions. So if the option to sort by Bin is true, you’ll hide the original tablix. If the option to sort by Bin is false, you’ll hide the second tablix.
