Borrower history entity
Find information about the Borrower history entity in Amlib OpenReports.
History by class
The Entity to select will depend on whether the Borrower Type keeps Borrower Reading History. It may be better to run the report from the Stock History to view the Item Return history for each Borrower or Borrower Class.
- Select New from the buttons of the Report Designer
- The Edit Report Window will display
- 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 “Borrower History by Class”
- Enter a Group if the Reports for example Borrower History
- Enter a Sub Group for example Class
- Choose Report Type from the Drop-down options (Table is default):
- Table – set out in rows and columns (select for the sample)
- Select Orientation
- Landscape (select for the sample)
- Leave Show sql
- Show details: For this sample Report we will leave as the Defaults
- All: To display all the details
- Show Sub totals if a calculation based on Groups is required (Default is unticked). For the sample tick this
- Show total if a Total calculation of the Sub totals is required (Default is unticked). For the sample tick this
- Tick Private For our sample leave this unticked.
- Show header on first page. For our sample leave this ticked
- Show header on next pages. For our sample leave this unticked
Display Fields
- Highlight the Borrower History Entity from the Entities / Data Fields
- Drag and drop the required Data Fields into the Display Field Column. In this sample we have Borrower History Date and Borrower History Title
Group
- Highlight the Borrower History Entity from the Entities/Data fields column
- Drag and drop Borrower Class to the Group field’s column which will base the Report by Class. Also drag and drop Borrower Full Name – Surname, Given to the Group fields column
Filter
- Select the Borrower History Entity
- Drag and drop Borrower History Type to the Filter
- Select Equal and select the History type (e.g. READING) from the Drop-down Options
- Drag and drop Borrower Class to the Filter. Select the Classes from the Drop-down list
- Drag and drop Borrower History Date to the Filter.
- Select Greater than or Equal and select a date from the Calendar (or choose Today – xx days)
Order by
It is useful to have an Order sequence to ensure it orders correctly
- Drag and drop Borrower Class over to the Order by section
- Select Ascending from the drop-down box
Preview
Select Preview to view the Report
Save
Once the Report is successful, save so it can be used again in the Viewer or Designer