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