CR_tips2_Formula

Heavy Reserved items

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. 

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

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

adult_fiction_list_greater_5_items._with_author A list of Adult fiction titles where we hold 5 or more items,  added after a certain date

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.