CR_tips1

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

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

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

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

dvdreservations A List of DVD titles with reservations