This report summarizes the number of held items transferred between library branches.
The report allows you to customize the results by selecting key parameters before generating the data. Specifically, you can set:
-
Date Range – Choose a start and end date to define the reporting period (e.g., 09/01/2025 to 10/01/2025). IMPORTANT - This report uses the polaris.polaris.ItemRecordHistory table, so it cannot report outside the limits you’ve established to keep this data (the report will come back blank).
-
Material Types – Filter by types of materials (e.g., books, audio books, or acquisition-on-order items).
-
Sending Branches – Select one or more library branches as the origin of the transferred held items.
-
Receiving Branches – Select one or more library branches as the destination for the transferred held items.
This is NOT SQL, this RDL file must be loaded into your SSRS server:
Held Items Transferred By Sending and Receiving Branch.rdl (35.5 KB)
The needed SQL is embedded into the file.
