Price of collections

heavy_reserved_report - includes orders

This report lists heavily reserved biliographic records. It includes order information (if present) as well as a count of copies.

To get this report to work you need to create a new table in your SQL database by closely following the instructions in the attached zip file AT YOUR OWN RISK. I personally had no problems following these instructions but if you get stuck I'm afraid you're on your own. Likewise if you break your database in some bizarre way. I think that's very unlikely but I have to limit my liability here...

We commissioned Civica (in the form of Trevor) to write this report for us. They are happy for me to share the report we paid for but if you can't get it to work and want some help with it I'm sure your account manager can work something out.

The first column is a basic calculation of reservations per item and order.
2nd column is the title and collection.
Then it's total copies, total resies, total on order copies and order date.

I hope it's useful.

Ken

reservations_excluding_dvd Titles which are heavily reserved, excluding DVDs

Heavy Reserved items

Ser_subs_complete A list of serial subscriptions sorted by branch and then by collection.  User can select start and end date of subscription to include in report

Branch CDs and DVDs on shelves Lists CDs and DVDs that are sitting on the shelves at our Fairfield branch ie. items not out on loan. It is sorted by call number and lists call number, title, accession number and the last sighted date of the item.(Spydus 8.2.5) From: Lianne Gee - Darebin Libraries

Create address labels from Community Info database This report is deisgned to produce address labels from the Community Information database. The report uses a simple concatenated field; suburb and postcode have been pasted together as a formula field called SubPost. Two parameter fields have been created to prompt for subjects and council ward codes, and sample subjects and ward codes have been built in to the report for selection. The prompts use "Like" rather than "Equals" to allow for searches on either full or abbreviated strings. Because we note names changes to names of local organisations in the 710 field, we have included a filter on organisation names with text like "*formerly*" to prevent labels based on this note. The formula in the report is : not ({HEADING_1.HEAD} like "*formerly*") and {HEADING.HEAD} like {?string} and {CON.POS} = 1 and {GAN.NOTE} like {?Ward Code} (Spydus 8.2) From: John Ruddle - Monash Public Library VIC