Monthly Discards Report (v.1) - select own dates

Ser_subs_complete_bytitle A list of serial titles.  Sorted by title and listing each branches individual subscription.  User can select end and finish date of subscription

Long_Overdue_selects_with_barcodes Produces a list of very long overdues,with accn numners in numeric and barcode font.  A work around for bulk processing items through circ maintennace.  I found the barcodes scan best if printed straight from crytsal Reports rather than saved to an excel file etc. 

Serials_issues_by_branch_and_date Before opening this report, set datasource location and change selection parameters for your library.

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

CR_tips1

A mixture of tips for using Spydus fields in Crystal reports such as creating initials from the First name field, create age groups, formulas and how to exclude deleted records from your select list.

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