Skip to main content
OCLC Support

Reservation entity

Find information about the Reservation entity in Amlib OpenReports.

Reservations ready

  1. Select New from the buttons of the Report Designer
  2. The Edit Report Window will display
  3. Enter a Report Title in the Report Title section. This can display at the top of the report. For the sample we can give a Title of “Reservations ready
  4. Enter a Group if the Reports for example Reservations
  5. Enter a Sub Group for example Ready for collection
  6. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample)
  7. Select Orientation
    • Landscape (select for the sample)
  8. Leave Show sql
  9. Show details: For this sample Report we will leave as the Defaults
    • All: To display all the details
  10. Show Sub totals if a calculation based on Groups is required (Default is unticked). For the sample untick this
  11. Show total if a Total calculation of the Sub totals is required (Default is unticked). For the sample untick this
  12. Private. For our sample leave this unticked.
  13. Show header on first page. For our sample leave this ticked
  14. Show header on next pages. For our sample leave this unticked

Display Fields

  1. Highlight the Reservations Entity from the Entities / Data Fields
  2. Drag and drop the required Data Fields into the Display Field Column. In this sample we have Borrower Full Name – Surname, Given, Reservation Item Title, Reservation Date Placed, Reservation Collection Location


  1. Select the Reservations Entity
  2. Drag and drop Reservation Status to the Filter
  3. Select Equal from the Drop-down Options
  4. Select the required Statuses from the Options. In this sample we have included Ready and Return
  5. It is also useful to choose a Date range – for example Greater and Equal to Today – xx days or select a specific date from the Calendar

Order by

There can be an order if required.


Select Preview to view the Report

Note: The Headings can be changed to make them neater!

Or include a Group of Borrower Full name – Given, Surname… so that the name does not repeat!


Once the Report is successful, save so it can be used again in the Viewer or Designer