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 in formulas - because it is after all, just the…
ToText
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 Australian financial year which is from July to June, e.g.…
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 all formatting. For example, the number 1000 in your data…
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 places. For example, you've used the 'Running Total Fields' to…
Word 2010 – How to Use AutoText
AutoText is a feature in Word 2010 which allows you to quickly insert predefined text, objects or pictures by simply typing a single keyword. Create a new 'building block' Using…