Skip to content
The following guide describes how to create a Crystal Report which will prompt for a FROM and TO date and...
Problem You’re attempting to use a number, which is a string, in a formula but the output has leading decimal...
The following code shows how to convert a number to text in a Crystal Reports formula – whilst also removing...
The following guide describes how to create a Crystal Report which will exclude the page header and footer from the...
If you’ve been looking for a way to automatically schedule and email Crystal Reports then there’s a free solution –...
The following guide describes how to filter (remove) duplicate rows by a particular field. In this example we are using...
The following steps describe how to create a Crystal Report which will prompt for a value and if nothing is...
The following guide describes how to create a Crystal Report which will keep grouped records on the same page. In...
Problem You’ve inserted a number field and left aligned only to notice that the output doesn’t align with other fields,...
Problem Using Crystal Reports you’re working with a field that contains numbers but when you open the format window the...
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 show how to make a Crystal Report show only unique records. This example is using Crystal Reports...
The following formula shows how to test if a text field contains particular text. For example: Value Formula Result a...
The following formula shows how to convert a date value to the day of the week. To do this we...
Text of dates in Crystal Reports can be annoying – you can’t apply any date-specific formatting or use the date...
By default when a Crystal Reports parses HTML tags literally – that is, it will output the tags without rendering...
Crystal Reports has three built-in functions for transforming the case of text. These are: ProperCase – for transforming text to...
Question What does the ‘Show on (Viewer) Panel’ option do in Crystal Reports? Answer The ‘Show on (Viewer) Panel’ option...
Problem When attempting to add a data source, such as a table, view or command, to a Crystal Report you...
The following guide describes how to create a Crystal Report which check if a field is blank (NULL or empty)...
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...
The following steps show how to display which filters have applied to a Crystal Report in the header of the...
The following steps show how to order a cross tab in Crystal Reports from largest to smallest – by default...
One of the issues faced by Crystal Reports administrators is that the free ‘Crystal Reports Viewer’ software only allows users...
The steps below detail how to use Crystal Reports to make fields apply formatting on a condition. For example, if the...
The steps below show how to display boolean true/false values as a checkbox with either a tick and/or cross. By...
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 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...