BAQ Query - Parts/LotNumber/On Hand Qty

Hi All,

I have a basic BAQ which shows Parts in bins and the QTY, being that some have multiple lot numbers of parts in the same bin. For this report the lot number is irrelevant

In either the BAQ or an SSRS report could this be shown as just 1 line with the total of the stock.

so for the below i would want it just showing 1 line and it to say the QTY is 11


Many Thanks

Without seeing your query and/or SSRS in more detail… my first though, on the SSRS side would be your Group properties… group by Part Number. You may have to change your qty field to =sum() to show the total.


Thank you for this i thought i’d tried this, must have made a mistake when doing it first time round.

all sorted