Skip to main content
OCLC Support

Current loans entity

Find information about the Current loans entity in Amlib OpenReports.

Overdues

  1. Access the Report Designer TAB
  2. Select New from the buttons
  3. The Edit Report Window will display
     
  4. Enter a Report Title in the Report Title section. For the sample we can give a Title of “Overdues”.
  5. Enter a Group since we want to find it later easily – for example Current Loans
  6. Enter a Sub Group – for example Overdues
  7. Choose Report Type from the Drop-down options (Table is default):
    • Table – set out in rows and columns (select for the sample)
  8. Select Orientation
    • Landscape (select for the sample)
  9. Leave Show Sql
  10. Show details: For this sample Report we will leave as the Defaults
    • All: Shows the break-down of details within the Fields (Default)
  11. Show Sub totals: Can be ticked if required
  12. Show total: leave this unticked
  13. Tick Private: leave this unticked
  14. Show header on first page: For our sample tick this one!
  15. Show header on next pages: This is your choice. But for now leave this unticked

Display Fields

  1. Highlight the required Entity from the Entities / Data Fields
  2. Drag and drop into the Display Field Table Item Fields from the Stockitem Entity – Item Title, Item Call No etc.
  3. Drag and drop into the Display Field Table required Fields from the Current Loans Entity – Issue Due Back Date etc.

Group Fields

It is possible to Group the Report by Borrower Class or Type, as well as the Borrower name etc.

  1. Add Borrower Class or Type to the Group fields
  2. Add the Full Name-Surname, Given Field to the Group Fields table
  3. It is possible to decide if you want a Page break for the Group field. For our Sample select Yes
  4. Preview the report again to see the changes. The Borrower’s name no longer repeats

Note: The Grouped Fields display as shadowed Text on the report, making it stand out

Filter

  1. To filter by All overdues select Item Issue Due Back Date from the Current Loans Entity
  2. Select Less than
  3. Select Today for the date to get all Overdues

Order by

It is not essential to have an Order because the Groups are already filtering the Data and will automatically display in ascending order. However it may be useful to have an Order sequence if the Order is to be descending or not as presented automatically

  1. Drag and drop Data Fields over to the Order by section
  2. Select either Ascending or Descending from the drop-down box
  3. In the sample report it is useful to Order it by Class and then Full name – Surname, Given in Ascending Order

Width

For the sample, notice the Call No had lots of space but the Title was sometimes a bit cramped. It is possible to change the width of the Call No Field and Title

  1. Return to Report Designer
  2. Select on the Item Call No Field
  3. Options will display
  4. Change the Width from 6cms to 4cms
  5. Select out of the box
  6. Change the Title width too, to make it from 8cms to 15cms in the same way
  7. Preview the report again to see the changes. There is now less space taken up by the Item Call No and the Item Title does not wrap so much

Save

Once the Report is successful it is useful to Save it to be available in the Report Viewer