BOFocus – Crystal Reports Tips – Tricks – Tutorials

Tag Archives

Using the picture function

The Picture Function can be used within a formula to print a string “2065555555″ in a telephone number format “(206)..

April 5, 2012 with 0 Comments

Creating your first formula

When creating formula’s within Crystal Reports, the Formula Editor is used.  The Formula Editor provides access to different..

March 28, 2012 with 0 Comments

Calculating the number of working days

The following will calucalate the number of working days between two dates. Simple replace {start_date} & {end_date} with your date..

March 26, 2012 with 0 Comments

Age calculation

The following formula will allow you to calculate a person’s age correctly: WhileReadingRecords; DateTimeVar begindate :=..

March 26, 2012 with 2 Comments

Adding a month/day or months/days to a date

Add months, days, years to a date field.  With the dateadd function, you can use any of the interval types listed below to add/subtact a..

March 26, 2012 with 0 Comments

Add Padding to a field

At times in may be necessary to add padding to a field. Some examples would be an export from Crystal Reports to Excel or a CSV file for..

March 10, 2012 with 1 Comment



To change the formatting for multiple text boxes at one time, hold the Shift key while clicking on each text box. Once they’ve all been selected, click on the desired formatting icon(s).