Crystal Reports Tuesday, 20 December 2011 by Crystal Reports – If field is empty select another field The following guide describes how to create a Crystal Report which check if a field is blank (NULL or empty)... Crystal Reports – Keep Group on same page The following guide describes how to create a Crystal Report which will keep grouped records on the same page. In... 1 Crystal Reports – Exclude page header and footer from last page The following guide describes how to create a Crystal Report which will exclude the page header and footer from the... Crystal Reports – Remove decimal places from string Problem You’re attempting to use a number, which is a string, in a formula but the output has leading decimal... 2 Crystal Reports – Prompt and Filter by Date The following guide describes how to create a Crystal Report which will prompt for a FROM and TO date and... 3 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 convert number to text without formatting (no commas and decimal) The following code shows how to convert a number to text in a Crystal Reports formula – whilst also removing... Crystal Reports – Filter duplicates by field The following guide describes how to filter (remove) duplicate rows by a particular field. In this example we are using... 1 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 – Blank space before number fields Problem You’ve inserted a number field and left aligned only to notice that the output doesn’t align with other fields,... 1 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 – ‘Sum’ option and Number formatting missing Problem Using Crystal Reports you’re working with a field that contains numbers but when you open the format window the... 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 – How to display selected date range parameter filter The following steps show how to display which filters have applied to a Crystal Report in the header of the... 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... 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... [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... 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 – Prompt for value, if empty use database The following steps describe how to create a Crystal Report which will prompt for a value and if nothing is... Free Crystal Reports viewer – with refresh! One of the issues faced by Crystal Reports administrators is that the free ‘Crystal Reports Viewer’ software only allows users... 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 – 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 – 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 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... [ANSWER] Crystal Reports – What does ‘Show on (Viewer) Panel’ do? Question What does the ‘Show on (Viewer) Panel’ option do in Crystal Reports? Answer The ‘Show on (Viewer) Panel’ option... 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)....
Crystal Reports – If field is empty select another field The following guide describes how to create a Crystal Report which check if a field is blank (NULL or empty)...
Crystal Reports – Keep Group on same page The following guide describes how to create a Crystal Report which will keep grouped records on the same page. In... 1
Crystal Reports – Exclude page header and footer from last page The following guide describes how to create a Crystal Report which will exclude the page header and footer from the...
Crystal Reports – Remove decimal places from string Problem You’re attempting to use a number, which is a string, in a formula but the output has leading decimal... 2
Crystal Reports – Prompt and Filter by Date The following guide describes how to create a Crystal Report which will prompt for a FROM and TO date and... 3
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 convert number to text without formatting (no commas and decimal) The following code shows how to convert a number to text in a Crystal Reports formula – whilst also removing...
Crystal Reports – Filter duplicates by field The following guide describes how to filter (remove) duplicate rows by a particular field. In this example we are using... 1
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 – Blank space before number fields Problem You’ve inserted a number field and left aligned only to notice that the output doesn’t align with other fields,... 1
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 – ‘Sum’ option and Number formatting missing Problem Using Crystal Reports you’re working with a field that contains numbers but when you open the format window the...
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 – How to display selected date range parameter filter The following steps show how to display which filters have applied to a Crystal Report in the header of the...
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...
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...
[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...
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 – Prompt for value, if empty use database The following steps describe how to create a Crystal Report which will prompt for a value and if nothing is...
Free Crystal Reports viewer – with refresh! One of the issues faced by Crystal Reports administrators is that the free ‘Crystal Reports Viewer’ software only allows users...
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 – 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 – 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 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...
[ANSWER] Crystal Reports – What does ‘Show on (Viewer) Panel’ do? Question What does the ‘Show on (Viewer) Panel’ option do in Crystal Reports? Answer The ‘Show on (Viewer) Panel’ option...
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)....