2009-06-26 10:52:23 UTC
There is a history of all items that were checked out in biblio_hist_dm. You can make other report file in /reports/defs (.rpt extension) with your criteria using sql.
I made something like that for me time ago. Perhaps it can help you .
.title checkouthistory
.category Circulation
.column bibid hidden
.column status_begin_dt hidden
.column barcode_nmbr sort=barcode_nmbr
.column title sort=title func=biblio_link
.column author sort=author
.column checkoutCount sort=checkoutCount
.parameters
. date date_begin title="From (mm/dd/yy)"
. date date_end title="To (mm/dd/yy)"
. string barcode title="Report by copy"
. order_by
. item barcode_nmbr
. item title
. item author
. item checkoutCount type=numeric
. end order_by
.end parameters
.sql
select b.bibid, c.barcode_nmbr, b.title, b.author,
h.status_begin_dt ,
count(h.status_begin_dt) checkoutCount
from biblio_status_hist h, biblio_copy c, biblio b
where h.bibid = c.bibid
and h.copyid = c.copyid
and h.bibid = b.bibid
and h.status_cd = 'out'
. if_set date_begin
and h.status_begin_dt >= %date_begin%
. end if_set
. if_set date_end
and h.status_begin_dt <= %date_end%
. end if_set
group by b.title, b.author
. if_set barcode
,c.barcode_nmbr
. end if_set
. order_by_expr
.end sql