There are a couple shared in Evergreen Indiana now. Under Shared Templates/jcpl-jasonb/Shared Templates/Collection there are "Simple Estimated Collection Value By Library" and " Detailed Estimated Collection Value By Library and Circulation Modifier"
To re-make the Simple one elsewhere: Using Item as the report source, Item->Call Number/Volume::Owning Library::Name is the first field displayed, the second is the Aggregate SUM of the Item::Price field. For Base Filters Item->Call Number::Owning Library is given an In List operator, (If you want. We have branches so I always use in list for libraries), Deleted equal to False, and then the Item::Item Status::id with a Not In List operator. This is for statuses you no long want to consider in your value, such as lost or discard. The "detailed" one just ads circ mod between Library Name and the Price sum. It is very nice with the Pivot Lable set to the circ mod. People using these obviously need to be aware that there will be things like: Items with no price (this doesn't use the default item price), items with the wrong price, items with the wrong status or circ mod, etc. They are a great place to start for estimates though. Jason -- Jason Boyer, IT Specialist Jackson County Public Library 303 W Second St Seymour, IN 47274 [email protected] p (812) 522-3412 ext. 227 f (812) 522-5456 On Fri, Mar 19, 2010 at 11:37 AM, Lemmer, Catherine <[email protected]>wrote: > > > Has anyone created or can one record a report to be used to ascertain the > value of a library's collection. The library is changing insurers and needs > to estimate the value of its collection. > Any recommendations? > Catherine > > ------------------------------ > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Amy > Terlaga > *Sent:* Wednesday, March 10, 2010 5:19 PM > *To:* [email protected] > *Subject:* [OPEN-ILS-GENERAL] Evergreen Canned Reports > > Hi all— > > > There was some discussion quite recently about reporting possibilities in > Evergreen. > > > > I thought that my recent blog post would be of some interest to you: > > > > http://biblio-os.blogspot.com/2010/03/evergreen-canned-reports-testing.html > > > > Amy > > > > ======================= > > Amy Terlaga > > Assistant Director, User Services > > Bibliomation > > 32 Crest Road > > Middlebury, CT 06762 > > (203)577-4070 x101 > > http://www.biblio.org > > ---- > > Bibliomation's Open Source blog: > > http://biblio-os.blogspot.com/ > > > > Join us on Facebook: > > http://www.facebook.com/group.php?gid=171935276419 > > >
