Capitalising report generator output

Summary

Sometimes it is useful to have the output of the Report Generator to be in a certain case ('UPPER' or 'lower' case). For example Royal Mail suggest it is good practice for computer printed addresses to be in capitals to help the sorting machines.

Method

$UPSTR{A03} would output the Account Name (A03) in upper case. Catalyst Computer Systems would become CATALYST COMPUTER SYSTEMS.

Just substitute 'A03' for any Report Generator text variable.

$LOSTR{} will do the same in the other direction, forcing lower case.

See also

• $LOSTR - Convert a string to lower case
• $UPSTR - Convert a string to upper case
• $CAPSTR - Convert a string to capital case

Feedback

Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'

Keywords AND Misspellings

capitalise, upper case, $UPSTR, $LOSTR, $CAPSTR