We are going to create a report where overdue items will be grouped by a borrower. There will be group header (borrower information) followed by the overdue items list.
In the grouped report you have to define Grouped By and then decide which data fields will be included in the Group Header.
Included Fields: I_BARCODE, TITLE, TYPE, LOANDATE, RETURNDATE
The total width of the report table is: 1 + 3 + 1 + 1 + 1 = 7. The table width is 7, it is less than the width of the printing area 7.5. Printing Area (7.5) = Page Width (8.5) - Left Margin (0.5) - Right Margin (0.5)
Group By: B_BARCODE Group Report Header: B_BARCODE, NAME, PHONE
How to change the column width?
Save report design for the future use.
Overdue items report in the Library Administrator window.
Remember, this report is using a View (Overdue Items View). If the report is run from the Library Administrator window the view will be executed. Only items that are overdue will be included in the report.
Question: I was hoping the loan receipt report for multiple "today's loans" could be modified. I'd like to add repeating text and be able to separate the borrowers by a few lines. We print, cut and include these in the books they check out in the facility. The check out receipt should tell them how to treat the book and that if they're late they lose chaplaincy privileges. We can adjust out process to print one receipt at a time however. Thanks again.
Answer: Use the same report layout as defined on this page, to print today's loans define the search in the Advanced Search: LOANDATE=CURRENT_DATE
Question: The Report entitled "Overdue Items By Borrower" is printing out every book that each student has ever checked out, even books that the student checked out and returned on time. What am I missing? Do I need to change something in the report?
Answer: You are executing this report in the Manage Loans window. If you select report from the Report box it will include all displayed items. Before you execute "Overdue Items By Borrower" report select Overdue in the Show section. Now only over due transaction are displayed and those transactions will be included in the report.
Handy Library Manager
Copyright © 2023 · All Rights Reserved · PrimaSoft PC