[Evergreen-reports] Circulation Report

[Jessica Venturo]

Hi all,

I am working with a librarian who is trying to run a collection analysis
for his library. He wanted to filter by Copy Location and Owning Library
and include the following columns in his report: Author, Title, Pub Year,
Call Number, Status,Owning Library, Copy Location, Total Circs, Total Circs
current year, Total Circs previous year. I can handle the filters and most
of the rest of it, but the last 3 columns have me stumped!

At first I thought I could use the pivot label column to display the
circulation by year as columns in a report, but I quickly learned it was
not meant to be used in this way. Next, I thought I could have him run
three separate reports - one for that showed circ for the current year, one
for the previous year, and one for total circs so that he could copy and
paste columns into the same spreadsheet. However, I found that any items
that had circulation outside of the entered date range did not show up in
the report.

I'm curious - has anyone been able to provide something like this for their
libraries? Any ideas would be greatly appreciated!

Thank you,
Jessica

-- 
Jessica Venturo
Applications Support Specialist
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070 x105
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20150116/e8f4c522/attachment.html>