Skip to content
If you’ve been looking for a way to automatically schedule and email Crystal Reports then there’s a free solution –...
Problem When running a Crystal Report you receive the following error message Division by zero. Solution Before describing how to...
The steps below show how to display boolean true/false values as a tick and/or cross. By default these values are...
Problem When attempting to add a data source, such as a table, view or command, to a Crystal Report you...
The following steps describe how to format a number so that it looks like a percentage. The obvious thing to...
The following steps show how to order a cross tab in Crystal Reports from largest to smallest – by default...
The following formula shows how to test if a text field contains particular text. For example: Value Formula Result a...
The following steps show how to make a Crystal Report show only unique records. This example is using Crystal Reports...
Sometimes you may come across dates that are strings in your data source, for example a date may be ’01/01/2012′...
Text of dates in Crystal Reports can be annoying – you can’t apply any date-specific formatting or use the date...
Problem When attempting to calculate previous month you recieve the following error message A month number must be between 1...
The following steps show how to display a NULL value (a blank value) as a 0. This can be helpful...
The following steps show how to display selected parameter values in a Crystal Report. For example, when running a report...
Problem When running a Crystal Report you receive the following error message: Prompting failed with the following error messages: ''....
The following steps show how to suppress blank detail rows in a crystal report. In this example the report does...
The following steps show how to make a field in a Crystal Reports display multiple lines, for example, if you...
By default when a Crystal Reports parses HTML tags literally – that is, it will output the tags without rendering...
The following formula shows how to convert a date value to the day of the week. To do this we...
The steps below detail how to use Crystal Reports to make fields apply formatting on a condition. For example, if the...
Crystal Reports has three built-in functions for transforming the case of text. These are: ProperCase – for transforming text to...
The steps below show how to display boolean true/false values as a checkbox with either a tick and/or cross. By...
The following steps show how to make the ‘details’ row in a crystal report using alternative line shading. In this...
The following code shows how to force a field in Crystal Reports to use Title Case (first letter upper case)....
The following code shows how to calculate the financial year from a date in a Crystal Reports. It uses the...