CR_tips3_Parameter

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

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

reservations_excluding_dvd Titles which are heavily reserved, excluding DVDs

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

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. 

Price of collections Here's a report of the cost of collections, grouped by collection. Includes a grand total, count of total items per collection and an average price per collection. Naturally you will need to set datasource to your server. And main.deactdate is null, otherwise you're counting all your withdrawals as well. Please test and see how you go. Also don't forget gigo, if you don't have a value in the field for price, it will distort the figures. - Gavin