adult_fiction_list_greater_5_items._with_author

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

CR_tips4_Age_Groups A detailed instruction for using age groups in Crystal Report's "Cross-Tab" report

Heavy Reserved items

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

CR_tips2_Formula Tips for using the formula option in Crystal Reports

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