Crystal Reports has three built-in functions for transforming the case of text. These are: ProperCase - for transforming text to Title Case LowerCase - for transforming text to lower case…

The following formula shows how to test if a text field contains particular text. For example: Value Formula Result a quick brown fox InStr( {value}, 'red' ) false a quick…

Text of dates in Crystal Reports can be annoying - you can't apply any date-specific formatting or use the date in formulas - because it is after all, just the…

The following code shows how to calculate the financial year from a date in a Crystal Reports. It uses the Australian financial year which is from July to June, e.g.…

The following steps show how to suppress blank detail rows in a crystal report. In this example the report does not have a 'user_name' value - leaving the row blank.…

The following steps show how to make the 'details' row in a crystal report using alternative line shading. In this example we will be using a light grey colour (RGB…

The steps below show how to display boolean true/false values as a checkbox with either a tick and/or cross. By default these values are displayed as either 'True' or 'False'.…

The following formula shows how to convert a date value to the day of the week. To do this we need to use: DayOfWeek - this takes a date and…

The following code shows how to force a field in Crystal Reports to use Title Case (first letter upper case). This is done using the ProperCase function. To use, create…