For each selected branch, this SSRS report displays the floating limit of each collection, the number of items assigned to the collection (which includes currently available, and in-transit to the branch), and the percentage of the limit taken.
SILS_Rpt_FloatingCollectionLimits.sql (4.4 KB)
Branch Floating Collection Limits.rdl (70.6 KB)