Handy Library Manager  for Windows


Help, how to topics > Custom Views > How to print of class lists of over due books at our small school library?


How to print of class lists of over due books at our small school library?

"I am hoping to print of class lists of over due books at our library. I am unsure how to do this."

Solution 1: In the loan.map file define mapping for EXTRA1 and/or EXTRA2 data fields. If you define EXTRA1=CUSTOM1, assuming you store class information in CUSOTM1, the borrower class value will be stored in the loan's EXTRA1 data field. With this data saved you can sort, group, search by class in the Manage Loans window. You can find loan.map file in the c:/handy_lib/data/db folder.

Solution 2: See our help topic on how to create a query in the Custom Views window.


SELECT B.NAME, B.CUSTOM1, C.TITLE, A.RETURNDATE, A.DUEDATE, A.LOANDATE FROM LOAN A JOIN BORROWERS B ON A.BOR_IDNO=B.BOR_IDNO JOIN LIBRARY C ON A.ITEM_IDNO=C.IDNO WHERE B.TYPE='Child' AND A.RETURNDATE IS NULL ORDER BY B.NAME

Tables and fields used in the query:

A - Loans table (LOAN), data fields: RETURNDATE, DUEDATE, LOANDATE, ITEM_IDNO
B - Borrowers table (BORROWERS), data fields: NAME, CUSTOM1 (student's class is stored in this field), BOR_IDNO
C - Libary Items table (LIBRARY), data fields: TITLE, IDNO

This part defines data displayed:
SELECT B.NAME, B.CUSTOM1, C.TITLE, A.RETURNDATE, A.DUEDATE, , A.LOANDATE

This part defines what tables are joined and by which data field:
FROM LOAN A JOIN BORROWERS B ON A.BOR_IDNO=B.BOR_IDNO JOIN LIBRARY C ON A.ITEM_IDNO=C.IDNO

This part defines conditions for results to be displayed:
WHERE B.TYPE='Child' AND A.RETURNDATE IS NULL

In order to print a report you will have to save the query and define grouped report by CUSTOM1 data field.


Questions:



Copyright © 2019 · All Rights Reserved · PrimaSoft PC