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... 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 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′... Problem When attempting to add a data source, such as a table, view or command, to a Crystal Report you... 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 order a cross tab in Crystal Reports from largest to smallest – by default... 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 selected parameter values in a Crystal Report. For example, when running a report... The following formula shows how to test if a text field contains particular text. For example: Value Formula Result a... By default when a Crystal Reports parses HTML tags literally – that is, it will output the tags without rendering... Text of dates in Crystal Reports can be annoying – you can’t apply any date-specific formatting or use the date... 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 make a field in a Crystal Reports display multiple lines, for example, if you... The following steps show how to suppress blank detail rows in a crystal report. In this example the report does... Crystal Reports has three built-in functions for transforming the case of text. These are: ProperCase – for transforming text to... The steps below detail how to use Crystal Reports to make fields apply formatting on a condition. For example, if the... The following formula shows how to convert a date value to the day of the week. To do this we... 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...