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 format a report section

Right-click the report section and click Format Section.