CR_tips2_Formula

Tips for using the formula option in Crystal ReportsTips for using the formula option in Crystal Reports
File Name: CR_tips2_Formula.pdf
Category: Crystal Reports
File Size: 283.64 KB
File Type: application/pdf
Created Date: 18-10-2010
Last Updated Date: 25-04-2020

Related documents

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
dvdreservations
A List of DVD titles with reservations
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_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.

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

Search